Forum Discussion
Solved
Filter data in heirachy
I am trying to filter data in this table so any customer above 15% should show only. I am having troubles creating a filter that allows me to filter at this level and keep the account rows under ...
Still doesnt quite sort it out. Its ok I have managed to find a way to do it.
HI,
you can use ISINSCOPE() function to work on the hierarchy level that you're interested in.
Here's the guide: Distinguishing HASONEVALUE from ISINSCOPE - SQLBI