Filtering child of hierarchies; not parent.
I have a chart where there is a column of (parent) PRODUCT TYPE sorted by sales, and nested below are the (child) PRODUCT NAME.
I want to be able to show only the TOP20 selling (child) PRODUCT NAME under each (parent) PRODUCT TYPE, but still show all the (parent) PRODUCT TYPE.
Currently when I add the filter, it filters the (parent) PRODUCT TYPE TOP20 only. I need the sort to affect the child, not the parent.
New user here - If there is a link somewhere explaining how to do this I'd really appreciate a pointer.
2 replies
-
Hi ,
There's a feature called N-of-N which allows this exact filtering logic (each level filtered within the scope of the previous level).
The only difference is that the feature requires all levels to be filtered, so you'll need to define a filter on the TYPE column as well. You could use a filter that returns all the TYPE, by asking for a the top 100000 for example (a limit which is higher than the actual member count).
https://help.pyramidanalytics.com/Content/Root/MainClient/apps/Discover/PRO/Query%20Functions/NofN.htm
-
Thank you