Skip to main content
Newcomer
Nov 18, 2022 8:05 PM UTC

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

Jaymin_0-1668801767344.png

 

1 reply

Employee - Sage
Nov 21, 2022 12:49 PM UTC

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.