Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table page field filtering
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Page field - pivot table | Excel Discussion (Misc queries) | |||
Pivot Table - Filtering Data Field | Excel Discussion (Misc queries) | |||
Pivot Table Page Field | Excel Discussion (Misc queries) | |||
Pivot Table Page Field | Excel Discussion (Misc queries) | |||
Pivot Table - Filtering Page Field | Excel Discussion (Misc queries) |