Quarter growth calculation

[#1]

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

[Gysbert_Wassenaar]

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