Stop Summary in the middle of Hierarchy List

I have this type of List.

ALL	Region	Country
World	Europe	France
		German
	Asia	China
		Japan

I want to Sum Lineitem by only Region not All, Like this Table.

List	Lineitem(None)	Lineitem(Sum)	Ideal
World		4	0
Europe		2	2
France	1	1	1
German	1	1	1
Asia		2	2
China	1	1	1
Japan	1	1	1

By calculating this table, I can filter Country List by Ideal Lineitem.

How can I stop the summary?

Accepted answers

kevin.cho

You can do this through a combination of hierarchy filters (Calculating Levels in a Hierarchy for Dashboard Fi... - Anaplan Community) and line items with summary method set to "Formula".

Create the hierarchy filter that will only be TRUE for your top level, and then in the "Ideal" line item, you can structure the formula as "IF NOT Top Level THEN Line Item (Sum) ELSE 0

All comments

Misbah

@hyudolee

What is it that you are trying to achieve? If it is about hiding World list item then right click on the module and you can choose "Select Levels to show" and uncheck the "L1 World List"

Misbah

kevin.cho

You can do this through a combination of hierarchy filters (Calculating Levels in a Hierarchy for Dashboard Fi... - Anaplan Community) and line items with summary method set to "Formula".

Create the hierarchy filter that will only be TRUE for your top level, and then in the "Ideal" line item, you can structure the formula as "IF NOT Top Level THEN Line Item (Sum) ELSE 0

hyudolee

Hi, @kevin.cho !

Thanks for replay!

I read this article, and this is what I wanted to do!

I could solve this problem.

Thank you!

Quick Links

Can you help?

Unanswered questions

Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…
Exports with anaplan using informatica connector
I'm trying to execute an Action to export data with the use of a Mapping in Informatica. But it gives us null rows .If we export directly from Anaplan , the export file has all the rows filled. Both exports have same number of rows but in the informatica export the values appear as blank. This issue is with only some…