Hi all
I'm having problems sorting data using report filters in a PivotTable.
I have a lot of organizational levels, and right now all org. units are shown when filtered.
The solution I am searching for is some kind of intelligent report filter. Intelligent in the sence, that if I choose a specific organization on level 3, I only want the relevant (underlying) organizations on level 4 -> lvl. 5 and so on.
How do I do so? I've tried to google my way out of it, but without luck.
Thanks in advance!
I'm having problems sorting data using report filters in a PivotTable.
I have a lot of organizational levels, and right now all org. units are shown when filtered.
The solution I am searching for is some kind of intelligent report filter. Intelligent in the sence, that if I choose a specific organization on level 3, I only want the relevant (underlying) organizations on level 4 -> lvl. 5 and so on.
How do I do so? I've tried to google my way out of it, but without luck.
Thanks in advance!