Skip to main content
Newcomer
Nov 9, 2023 1:57 PM UTC

Cube views row calculation

Hi All,

 

I need to calculate the base members and roll up to Total member as shown in the below picture I tried using GetDataCell formula but am getting error, can anyone suggest how to do that.

Please find the below snaps for your reference. Thanks in Advance.

STDN_2-1699538247497.png

 

STDN_0-1699537990368.png

 

 

1 reply

Employee - Guide
Nov 9, 2023 4:10 PM UTC

The easiest way to accomplish (and maintain) adding/subtracting of members is to create a parent in the dimension library and set the required aggregation weight on each child.