Skip to main content
S
SofiaCuadra
Newcomer
August 22, 2023

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

  • August 22, 2023
  • 2 replies
  • 0 views
 
 

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

E
OneStream Employee
EricOsmanskiOneStream Employee
OneStream Employee
August 22, 2023

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
    MikeG
    Contributor
    August 22, 2023

    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.

      Terms & ConditionsAccessibility statement