Filtered list doesn't show all level of hierarchy

Highlighted
Contributor

Filtered list doesn't show all level of hierarchy

Hi 

 

I've created a filter using a list. Set it up as a boolean to only show products that I want to see. 

 

Issue is when I apply the filter i see the correct list - not the parents. I can't select the parents only the children. 

 

Any idea on what I'm missing. 

Message 1 of 7
6 REPLIES 6
Community Boss

Re: Filtered list doesn't show all level of hierarchy

Summary options for booleans default to None

Try setting that to ANY and the parents will show

David

Message 2 of 7
Certified Master Anaplanner

Re: Filtered list doesn't show all level of hierarchy

HI @hina1994,

If you want to see the above level hierarchy please change the summary of the Boolean formatted line item to "All" or "Any".

"All" - The parent will be seen only if all the child are ticked.

"Any" - The parent will be seen if any one of its child is ticked.

I hope this helps.

Regards,

Kavin.

 

Message 3 of 7
Contributor

Re: Filtered list doesn't show all level of hierarchy

 Thank you both! That did the trick  

Message 4 of 7
Occasional Contributor

Re: Filtered list doesn't show all level of hierarchy

Hi All,

This certainly did the trick. However, I am using the Boolean the filter to select only few child items and the parent total is not the actual total of the selected child item, rather the total of all the child items. Any suggestions just to obtain the total of the selected items..
Message 5 of 7
Certified Master Anaplanner

Re: Filtered list doesn't show all level of hierarchy

HI @Asslam,

In the line item(Or create a new line item) put a condition saying "If Boolean then Data else 0". Now the total should match with the selected children.

I hope this helps.

Regards,

Kavin.

Message 6 of 7
Occasional Contributor

Re: Filtered list doesn't show all level of hierarchy

Hi @kavinkumar , Thanks for the tip, it did the trick.

 

However, I had build multiple views with different filter to build different dashboard reports.Therefore, with this approach I don't think I would be able use this IF condition as this would not work with my different views. When I write the IF condition and select the boolean then my line item becomes specific to the single sections.

 

Thanks 

Asslam 

Message 7 of 7