AnsweredAssumed Answered

Weekly Summary of daily amounts available for chart

Question asked by JamesWatt on May 19, 2012
Latest reply on May 23, 2012 by Sorbsbuster

Title

Weekly Summary of daily amounts available for chart

Post

I have daily revenue numbers that i would like to summarize (total) weekly by week number, and then use that total in a chart, preferably compared against last years's numbers.  I can create a summary (when sorted by week number) but can't use that in the chart.  I've tried creating a summary field but that just gives me 6 entries for each week (we're open 6 days) with the the summary number being correct (a total of the revenue per week).

Any ideas most appreciated.  This is getting a bit frustrating.

Thanks.

James.

Outcomes