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!
Could you post workbook with your data and a small example of what you want to achieve, I think I understand but best to be sure.
Bookmarks