Calculations for report

[dbdesign]

I have a "Product Line Items" file. Each product has a category associated with it. I need to do a report that will show me the total sold for each category for each Invoice Date.

 

I need the report to show all of the totals across 1 line: ie

 

March 24, 2005 1000.00 250.00 875.00

 

with each value being a total of each category for that invoice date. I tried using GetSummary but I don't know if that's correct or how to do it for each seperate category.