3 Replies Latest reply on Oct 24, 2013 3:48 PM by Louis Keating

    Column and Line Chart - Running Total of Values Outside Filter

    Louis Keating

      Hey All,

       

      I'm trying to replicate a chart I've done in Excel. It's a column chart showing registrations by month. The date range is driven by a date slider (e.g. Jan 2013 to Oct 2013). I've successfully added a running total line and made the chart Dual Axis but it shows the running total of the bars in the current window.

       

      I want the running total to start counting in May 2012, and not just for the current range.

       

      Is this possible? I've been looking into LOOKUP, WINDOW_SUM but I can't seem to get it to work.

       

      Any ideas?

       

      Thanks

      Lucas