Quarter growth calculation

Mon, 11 May 2015 15:25:57 GMT

Hi,

i would like to calculate the quarter growth.

Basically I have a measure Value and Time Dimension which contains quarter (MATIME_PERIOD) , like that:

2014Q1

2014Q2

2014Q3

2014Q4

2015Q1... and so on.

I have a table with quarter as dimension where i would like to calculate the previous value. I have calculated it as:

sum({<MATIME_PERIOD = {"$(=left(MaxString(MATIME_PERIOD),4)-1

&right(MATIME_PERIOD,2))"}>} Proj__Default_Crp)

Unfortunately it's not working, anyone can help on the same.

Thanks,

Antonello

Re: Quarter growth calculation

Gysbert_Wassenaar — Mon, 11 May 2015 15:47:42 GMT

The set analysis expression calculates a set at the chart level, not at the level of the dimension values in the chart rows. But you can try it another way. See this document: Calculating rolling n-period totals, averages or other aggregations