Set up filter to select levels of hierarchy to show

alec_judd

I have three lists all in one hierarchy (L1, L2, and L3).  How can I set up a filter using booleans to allow users to select which level of the list they want to see?  L1 is parent of L2, and L2 is parent of L3. I'm trying to replicate the functionality of "Select Levels to Show" so that I can set the filter on multiple grids.  Since there are three different grids on the dashboard that I would use this on, it's less work to check this one filter than Select Levels on all three grids each time they use the dashboard.

daiju.muto

I also want to know how to solve this issue.
I tried various methods in Summary: Formula, but failed.
I think that this problem can not be solved by not having common variables in multiple Lists with parent-child hierarchies.
If anyone can solve it, I would like you to post it here!

DavidSmith

@daiju.muto

Take at look at these

https://community.anaplan.com/t5/Shared-Best-Practices/Calculating-levels-in-a-hierarchy-for-dashboard-filtering/ta-p/33567

 

https://community.anaplan.com/t5/Modeling/Configuring-a-filter-for-nodal-values/td-p/32478

 

They might help you for your use case

David

daiju.muto

Thank you for giving me an accurate answer!
I will deliver this to our customers.