## Stop Summary in the middle of Hierarchy List

Occasional Contributor

## 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?

1 ACCEPTED SOLUTION

Accepted Solutions
Certified Master Anaplanner

## Re: Stop Summary in the middle of Hierarchy List

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

3 REPLIES 3
Moderator

## Re: Stop Summary in the middle of Hierarchy List

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

Certified Master Anaplanner

## Re: Stop Summary in the middle of Hierarchy List

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

Occasional Contributor

## Re: Stop Summary in the middle of Hierarchy List

Hi, @kevin.cho !

Thanks for replay!