7 Replies Latest reply on May 23, 2012 12:03 AM by Sorbsbuster

    Weekly Summary of daily amounts available for chart

    JamesWatt

      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.