Are you able to place a portal to Table One on your Table Two layout that lists the values you want as wedges in your pie chart, one portal row for each "wedge"?
But I think that using another table tha summarice the information could do the job. But for every date of report Iwill have to change the value of the date of report. I'm right?
If you can't get that kind of portal display, then you won't be able to get your pie chart to chart data from the related records correctly as far as I know.
While you could do it that way, I don't see why you'd need to change the date each time.
All you've descrbed for table 2 is a single field, Date of Report.
If you simply create a new record with a different date of report each time and have this relationship:
Table2::DateofReport = ChartElements::DateofReport
Then you can have a different chart for each date, just by clicking from record to record while in form view.
"ChartElements" could be a new table needed to get the records to relate as needed for your pie chart or Table 1 might serve--it depends on how you've structured your data in that table.
so in order to vie the elements in categories I have to create a new table of categories for each "date of report"
asset;category;date of report;bank;market value
Category;date of report;bank;"sum(tableone::Market Value)"
Table Categories::Date of report=Tableone::date of report
TAble Report::Date of report=table categories::date of report
The records of the Table must be created every time a import the data in table one.
My results are very poor
i want to keep simple and for every date of report , bases on calculations and relationships get my chart
Not quite, Any reason TableOne can't be used for this? Do you have one record per category per date in this table? If so, then you don't need the categories table.
If you need the categories table, you need this relationship:
Categories::DateofReport = TableOne::DateofReport AND
Categories::Category = TableOne::Category
(Note that Category might just be some type of asset identifier if each asset is to have its own wedge in the pie chart.)