Displaying Total but not the underlying Items

HugoVolpi

Hi all,

i have an unusual demand regarding a dev, I am asked to display the value of a parent but not the childrens value, however the items are displayed.

Basically, i have a Hierarchy that goes from C1 to C5, but the focus here is on C4 and C5.

I need to do something like this :

The "A" Parent is on C4 Level, and the A.1, A.2,… are on C5 Level.

I have tried DCA on C5 Level but it also shadows the "A" Parent value, any ideas ?

thank you very much,

rob_marshall

@HugoVolpi

I think you can accomplish with DCA as well as a summary method of Ratio. First, ensure your summary method for the DCA is None, that should only hide the detailed members. Next, set the summary format to RATIO for the line item like the below:

Ensure your Ratio Divisor is not dimensionalized by anything (is blank in the Applies To) and has a summary as none.

Sai_Bharadwaj_Venati

Another approach would be create a new line item in the same module and in applies to instead of selecting C5, select C4. This will create a subsidiary view but will solve your problem

HugoVolpi

Hi @Sai_Bharadwaj_Venati , @rob_marshall ,

I could implement based on your first idea @rob_marshall , i just modified the principle a bit but indeed i had to work it through the ratio.
See below,