Cube View - Quarterly Growth Calc

[Jaymin]

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

[JackLacava]

This is very simple to achieve. You might want to check the section "Calculated Columns and Rows with References to Member Filters" in the Design and Reference Guide.