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.