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

FlorDataSolutions MultiLevelFilter.JPG

Accepted answers

All comments

rob_marshall

@Antonio_Flor

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

Antonio_Flor

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

JaredDolich

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

kavinkumar

@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.

CommunityMember112758

@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.

DEFLOTHE

It looks great, could show the filter behind.

Quick Links

Can you help?

Unanswered questions

Prevent end users deleting a list item when using Worksheet in UX.
Hi, I have a worksheet for end users to enter new hires into, for which the list item which persist across versions. I am having an issue where the end user can delete a list item using the grid functionality because the Current Version value is blank, but I want to prevent them deleting them (as data will be lost from…
Introducing Anaplan API Python SDK
Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support all APIs including ALM, SCIM, Audit, and Cloud Works. Please…
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…