## [Guide] Multi Level filter selection on composite hierarchy

Master Anaplanner/Community Boss

## [Guide] Multi Level filter selection on composite hierarchy

If you are using a multi level composite hierarchy as your main reporting list (as you should vs ragged), you have encountered the need to filter it and display many levels of it in many different dashboards.

Recently re-discovered  a solution that I find quite handy and decided to share it here.

Here's the result. As you can see below, a user can select any level of the hierarchy, one by one and then all is concatenated into a final line item that you can use as a filter, to create the two grids below.

I'm adding a "filter" dimension to that module so you can have several filters pre set.

How do you achieve this ? Like this:

And here are the formulas:

The trick is on the summary level being Ratio. This allows us to bring the value of a parent level into the summary level of a child, like this:

Nathan Rudman, Anaplan Model Builder
6 REPLIES 6
Moderator

## Re: [Guide] Multi Level filter selection on composite hierarchy

Finally got to this. Amazed this isn't a best practice. We really need a good solution for the filtering. Thank you for posting this!

Jared Dolich
Certified Master Anaplanner

## Re: [Guide] Multi Level filter selection on composite hierarchy

@nathan_rudman  thanks for sharing.. .

@JaredDolich  there was some old article in some previous Community releases... I am not able to find it anymore the original solution.

I found only this post

https://community.anaplan.com/t5/Best-Practices/Calculating-Levels-in-a-Hierarchy-for-Dashboard-Filt...

I always used this solution for multi-level filtering.

Ratio summary method: really powerful. I also used it for example to "stop" the aggregations from some level up.. (for example when you do not want to have Local Currencies values aggregated at Total Group... 🙂 )

Moderator

## Re: [Guide] Multi Level filter selection on composite hierarchy

Can't believe I missed that. Thank you!!

Jared Dolich
Master Anaplanner/Community Boss

## Re: [Guide] Multi Level filter selection on composite hierarchy

This method been around "officially" since 2015 at least, I don't claim to have invented it 🙂

Nathan Rudman, Anaplan Model Builder
Certified Master Anaplanner

## Re: [Guide] Multi Level filter selection on composite hierarchy

@nathan_rudman  any good idea said it and re-said it does not heart 🙂

Master Anaplanner/Community Boss

## Re: [Guide] Multi Level filter selection on composite hierarchy

I remember when my boss then had the idea it was possible, he challenged me and another guy, who managed it first.

T'was the days !

Nathan Rudman, Anaplan Model Builder