How to create/calculate a cumulative measure for Sales?
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).
Re: How to create/calculate a cumulative measure for Sales?
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