How can I sum all child components of the same column in a cell in cube view?
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
Forum Discussion
Look into Cube View Row (CVR) calculations. Here is a screenshot of the section in the Design and Reference Guide.
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.
