How to aggregate aggregates in report RRS feed

  • Question

  • I'm using sql 2008 reporting services ,and running a query which returns monthly totals. So, think a simple dataset with "month" - "total" such as may - 20, jun -40, jul -75,etc

    What i need to do is then take this data and aggregate it on a bar chart, where each month's totals are added to the previous months totals. So per the example above, the chart would have a final data set of

    may -20, jun -60, jul - 135 . etc. How can i do that?

    Thanks for you help

    Wednesday, September 23, 2009 1:43 PM


  • i guess you're looking for the RunningValue() expression
    • Proposed as answer by Jerry Nee Friday, September 25, 2009 6:37 AM
    • Marked as answer by Jerry Nee Friday, October 2, 2009 7:35 AM
    Wednesday, September 23, 2009 1:53 PM