Displaying Total but not the underlying Items

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,

Accepted answers

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

All comments

rob_marshall

@HugoVolpi

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,

Quick Links

Can you help?

Unanswered questions

Excel date format for February 2030, 2031 and so forth don't align with Anaplan format
Hello, I’m running into a recurring issue when importing CSV files into Anaplan, specifically with dates in February for the years 2028, 2029, and beyond. Here’s what’s happening: In Excel, the date format is set to Custom (e.g., 2/26/2025). When imported into Anaplan, the date is interpreted as 26-Feb, where: Month = Feb…
RANKCUMULATE not working when adding additional dimensions to module
I have an issue where I am getting the expected result from RANKCUMULATE when using one dimension, but when I add an additional scenario dimension to the module, it doesn't calculate the way I'd expect. Here are some screenshots to explain the case: Module 1 - calculates cumulative total for list items in list "Age"…
Introducing Anaplan API Python SDK
Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support all APIs including ALM, SCIM, Audit, and Cloud Works. Please…