Jaymin
3 years agoNew Contributor II
Cube View - Quarterly Growth Calc
Hello,
I am building the Cube View. As you can see below, I have Quarters in columns and now I want to add new rows for Qtr growth. How to achieve the formula for Quartly growth? I want to compare the current Qtr to the prior year's Qtr in New Row. Below is the formula.
Formula: (Current Year Qtr - Prior Year Qtr)/Current Year Qtr*100