Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to create a line chart that is a cumulative measure of sales at any given period. For example, using sample data below, if I selected year 2015 in my filter, I would get an upward sloping line that summed up all prior and current sales for any given month in 2015. So for the month of Mar 2015, I would get cumulative sales of $30 (10+5+15).
Year | Qtr | Month | Sales |
2015 | Q1 | Jan | 10 |
2015 | Q1 | Feb | 5 |
2015 | Q1 | Mar | 15 |
2015 | Q2 | Apr | 20 |
2015 | Q2 | May | 35 |
2015 | Q2 | Jun | 60 |
2015 | Q3 | Jul | 20 |
2015 | Q3 | Aug | 50 |
2015 | Q3 | Sep | 40 |
2015 | Q4 | Oct | 30 |
2015 | Q4 | Nov | 75 |
2015 | Q4 | Dec | 80 |
2016 | Q1 | Jan | 10 |
2016 | Q1 | Feb | 10 |
2016 | Q1 | Mar | 30 |
2016 | Q2 | Apr | 40 |
2016 | Q2 | May | 70 |
2016 | Q2 | Jun | 120 |
2016 | Q3 | Jul | 40 |
2016 | Q3 | Aug | 100 |
2016 | Q3 | Sep | 80 |
2016 | Q4 | Oct | 60 |
2016 | Q4 | Nov | 150 |
2016 | Q4 | Dec | 160 |
Hi
try
=RangeSum(Above(TOTAL Sum(Sales), 0, RowNo(TOTAL)))
getting close, but not working fully yet. Does my raw data table have to be in sequential order? I have a lot of different dimensions in my data and so the data is not necessarily in order. I have grouping dimensions (ie, categories/hierarchies) that may be complicating things