"Intelligent" report filter

Koppel

New member
Joined
Mar 19, 2014
Messages
1
Reaction score
0
Points
0
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!
 

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,942
Reaction score
0
Points
36
Excel Version(s)
O365
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.
 
Top