I have a pivot table with multiple iteam in the "Page" area. Two of them are
Account Manager & Customer Name. When I select a specific Account Manager it
still shows all the customer names for all of the account managers. Is there
a way in a pivot table to select an Account manager and the Customer Name
would be specific to that account manager instead of all of the data? I
cannot move either of the fields into the "Row" area as the view has to
specfic for each account manager and each customer site....
I'm using MS Excell 2000.
Thank you.

No, the pivot table page filters aren't dependent on the other filters
and there's no way to change that behaviour.

murkaboris wrote:
I have a pivot table with multiple iteam in the "Page" area. Two of them are
Account Manager & Customer Name. When I select a specific Account Manager it
still shows all the customer names for all of the account managers. Is there
a way in a pivot table to select an Account manager and the Customer Name
would be specific to that account manager instead of all of the data? I
cannot move either of the fields into the "Row" area as the view has to
specfic for each account manager and each customer site....
I'm using MS Excell 2000.
Thank you.


--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com

Thank you Debra.

"Debra Dalgleish" wrote:

No, the pivot table page filters aren't dependent on the other filters
and there's no way to change that behaviour.

murkaboris wrote:
I have a pivot table with multiple iteam in the "Page" area. Two of them are
Account Manager & Customer Name. When I select a specific Account Manager it
still shows all the customer names for all of the account managers. Is there
a way in a pivot table to select an Account manager and the Customer Name
would be specific to that account manager instead of all of the data? I
cannot move either of the fields into the "Row" area as the view has to
specfic for each account manager and each customer site....
I'm using MS Excell 2000.
Thank you.


--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com