Multilevel filter with just one Boolean

Highlighted
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

5 REPLIES 5
Highlighted
Master Anaplanner/Community Boss

Re: Multilevel filter with just one Boolean

@Antonio_Flor 

 

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

Highlighted
Occasional Contributor

Re: Multilevel filter with just one Boolean

That’s correct. Ratio summary is part of the trick .
Highlighted
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.

Highlighted
Master Anaplanner/Community Boss

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
Highlighted
Master Anaplanner/Community Boss

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.