Hi,

I have a question about filtering and pivot table. Support I have an
Employees dimension, which has a parent-child hierarchy to match the
management hierarchy. I also have another dimension called [City].

Suppose my management hierarchy, together with where that person lives, look
like this:

Tom (Seattle)
|----- Kate (Seattle)
|----- Jimmy (New York)
|----- Patrick (Tokyo)

Linda (Portland)
|----- Susan (Denver)
|----- Willis (Portland)


Using pivot table in Excel, I can easily see the drill down the hierarchy
and see the aggregated measures. However, suppose there are hundreds of top
level managers, and so as a user I want to first filter the top managers down
to a specific city (e.g. Seattle). However, if I apply the City=Seattle
filter, I will filter out the reports as well, and so Jimmy and Patrick will
be filtered out. But thats not what I want.

Is it possible to apply the filter only on the first level? Can I achieve
that using two pivot tables?

Thanks,
Patrick