Cube views row calculation

STDN
New Contributor III

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 1

chul
Contributor III

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. 

cds