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

 

Cube View

1 Reply

Sort By
  • JackLacava's avatar
    JackLacava
    Community Manager
    3 years ago

    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.