charting categories problema

[camacorp]

Hi

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.

Table One

Asset; category; date of report; bank;value

Table Two

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.

please help

regards

CAM