11-18-2022 03:05 PM
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
11-21-2022 07:49 AM
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.