QuarterYear Growth Rate calculation

[satishkurra]

Hi

I'm currently populating the Revenue and Growth Rate by YearQuarter dimension (Attached for reference)

Rev: Sum(Revenue)

Growth Rate: Sum(Revenue)/Above(Sum(Revenue))-1

Growth Rate is calculating the above dimension value as populating the growth rate.

What i need is the Growth Rate comparing the prior year quarter

Example: 2017 Q1 vs 2016 Q1, 2018 Q2 vs 2017 Q2 and calculate the growth rate instead of taking the above value in dimension.

Please help.

Thanks

Satish

[satishkurra · Accepted solution]

Resolved this with below expression for Growth Rate

Sum({<Type={'BU'},FiscalYear=>}Revenue)/1000000)/Aggr(Above(Sum({<Type={'BU'},FiscalYear=>}Revenue)/1000000),Fiscal_Quarter,FiscalYear)

-1