Pivot table page field filtering

  • Thread starter Thread starter murkaboris
  • Start date Start date
M

murkaboris

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table - Problem with % 5
How do I Create another pivot table, based on the first one. Thank 8
Pivot Table Help 1
2003 Pivot Table Filter (items dropped in the Page Fields) 1
Pivot Table Page Field value from cell in another worksheet 3
Excel Pivot Tables 1
Pivot table filter list - listing irrelevant subcategorys 1
Pivot Table "Difference From" Question 4

Back
Top