How to create/calculate a cumulative measure for Sales?

[john_henry]

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

[handry_orozco]

Hi

try

=RangeSum(Above(TOTAL Sum(Sales), 0, RowNo(TOTAL)))

[john_henry]

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