How can I sum all child components of the same column in a cell in cube view?

SofiaCuadra
New Contributor
 
 

SofiaCuadra_1-1692692326785.png

 

Hi,I would like to add up all the children of the accounts and put them in the getdatacell, to create a row of Total, both for flow1, flow2 and flow3

 

2 REPLIES 2

EricOsmanski
Valued Contributor

Look into Cube View Row (CVR) calculations. Here is a screenshot of the section in the Design and Reference Guide.

EricOsmanski_0-1692708507864.png

 

MikeG
Contributor III

Or, create an alternate reporting hierarchy with those members that role up to a common parent.  CVR works too but if that Parent member should be repeatable (i.e. available for an ad hoc Quick View) then I would create an alternate reporting hierarchy in the Dimension Library.

Hope this helps.