Forum Discussion

Jaymin's avatar
Jaymin
New Contributor II
3 years ago

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

 

1 Reply

  • JackLacava's avatar
    JackLacava
    Community Manager

    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.