AnsweredAssumed Answered

Monthly Report by Item

Question asked by jaygs on Jan 30, 2012
Latest reply on Jan 30, 2012 by RayCologon

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.

Outcomes