Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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