Skip to main content
J
Jaymin
Newcomer
November 18, 2022

Cube View - Quarterly Growth Calc

  • November 18, 2022
  • 1 reply
  • 0 views

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

J
OneStream Employee
JackLacavaOneStream Employee
OneStream Employee
November 21, 2022

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.

    Terms & ConditionsAccessibility statement