Acumulative sum where you have so many dimensions

[Anonymous]

I'm trying to get value like the attached QVW in a pivot table. But my data is very large and I do have many dimensions (more than 15)

How do you think the best practice to achieve this?

[sunny_talwar]

I am not completely sure I follow what the concern is

[Anonymous]

I choose the period from 7/31/2013 to 7/31/2015. but the data from Jan 2016 appears, which is not in the range of the date i selected

[sunny_talwar · Accepted solution]

You can use set analysis in the Avg(1) field to restrict to your date range

RangeSum(Before( Count({<FLAG={'INV'},AssetStatusID={'REP','INV'},DATEPERIOD=, Year, Month}>} AssetModelKey), 0, ColumnNo())) * Avg({<DATEPERIOD = {">=$(=Date(vDateFrom2, 'M/D/YYYY'))<=$(=Date(vDateTo2, 'M/D/YYYY'))"}>} 1)

[Anonymous]

This is great.

Thanks!