From an invoice line item file I am trying to create a report to show monthly shipped totals by item over an 18 month period.
I can show totals of a found set in a sub-summary, but this report seems to need multiple found sets to execute the monthly totals. Either that or I am missing something.
I would like it to display in a table type format as below
Jan-2012 Dec-2011 Nov-2011 etc
Item 1 10 15 12
Item 2 35 20 23
Thanks in advance for any help.