Multilevel filter with just one Boolean

Antonio_Flor
Occasional Contributor

Multilevel filter with just one Boolean

I've seen a couple of posts about this topic but none ould deliver the level of flexibility and simplicity the client was asking for.

 

With a  combination of formulas and summary levels I've got this user-specific  multilevel selector for a dashboard.

 

Let me know if you have any questions.

Multilevel Boolean filter 

A

FlorDataSolutions MultiLevelFilter.JPG

6 REPLIES 6
rob_marshall
Moderator

Re: Multilevel filter with just one Boolean

@Antonio_Flor 

 

This is great, I assume you are using the Ratio summary?

Antonio_Flor
Occasional Contributor

Re: Multilevel filter with just one Boolean

That’s correct. Ratio summary is part of the trick .
CommunityMember112758
New Contributor

Re: Multilevel filter with just one Boolean

@Antonio_Flor 

 

Can you please describe little more what is the functionality between Boolean and multilevel filter.

 

I tried all mentioned steps but did not get the same output.

JaredDolich
Moderator

Re: Multilevel filter with just one Boolean

@Antonio_Flor 

Glad I clicked on the link that takes me to the video.

This is well done!

How did you get the refresh icon on the button?


Jared Dolich
kavinkumar
Certified Master Anaplanner

Re: Multilevel filter with just one Boolean

@JaredDolich, It's a Unicode character that you get it online. But I hope Anaplan suggest not to use 'Unicode Characters' as it might have an impact on the performance of the model.

@Antonio_Flor Great job. 

Regards,
Kavin.
DEFLOTHE
New Contributor

Re: Multilevel filter with just one Boolean

It looks great, could show the filter behind.