i have a terrible charting and report problem
i want to chart categories of a database base on a related set of records.
The structure of the database is a table of financial assets each one belongs to a category.
Every month I receive the fair value of the assets that are being managed by differents banks.
Asset; category; date of report; bank;value
Date of report
For ech "Date of report" record I want to visualize a pie chart by category for each bank of the related records of thar date of report
I can´t get that kind of chart.