08-22-2023 04:27 AM
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
08-22-2023 08:48 AM
Look into Cube View Row (CVR) calculations. Here is a screenshot of the section in the Design and Reference Guide.
08-22-2023 09:14 AM
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.