Weekly Summary of daily amounts available for chart
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.