Multilevel filter with just one Boolean

Options
Antonio_Flor
Antonio_Flor Member, ALL USERS, Community Pioneer Posts: 5 Master Anaplanner of the Year

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

Tagged:

Comments

  • Antonio_Flor
    Antonio_Flor Member, ALL USERS, Community Pioneer Posts: 5 Master Anaplanner of the Year
    That’s correct. Ratio summary is part of the trick .
  • CommunityMember112758
    CommunityMember112758 Member, ALL USERS, Community Member Posts: 2 New Contributor

    @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
    DEFLOTHE Member, ALL USERS, GroupMember, Certified Model Builder Posts: 4 Occasional Contributor

    It looks great, could show the filter behind.