"Intelligent" report filter

[Koppel]

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]

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.