Hi
I want to group the values associated to a custom date period. Currently I have sales data by month, what I want to do is to display the total sales by annual total. So as an example the annual total of October 2011 would be the sum of November 2010 sales through to October 2011 to account for a full year.
I would also like to compare this to the same annual total of the previous year, for example:
Oct 2010 annual total = X (sum of Nov 09 - Oct 10)
Oct 2011 annual total = X (sum of Nov 10 - Oct 11)
The database for this report is updated each month, so it would be great if the report updated with the latest months addition.
Hope this makes sense,
Many thanks
Chris
11 risposte
