Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table shows all rows in selection
I have numerous similar pivot tables that were converted to excel 2007.
They have the salesmen in the report filter and customer in the row filter. When I select a salesman in the report filter it shows the customers for that salesman. Then when I click the customer filter to select specific customers, some of the files show all customers for all salemen while the rest only show customers based on the salemens selected in the report filter. Any ideas on why the files are behaving differently? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pivot table - shows zero when should not be | Excel Discussion (Misc queries) | |||
Top 20 pivot table shows more than 20 | Excel Discussion (Misc queries) | |||
Looking for pivot table functionality that shows detail instead of count | Excel Discussion (Misc queries) | |||
The last row of a pivot table shows blanks, but there is data. | Excel Worksheet Functions | |||
pivot table selection | Excel Worksheet Functions |