| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why cant I exclude items with no data from the Page Field?
In a pivot table lets say I have one page field "Country" and another page
field "City". If I select England from "Country" I still get all the cities in the page field "City" regardless if the city is in England or not. I just want the English cities to select from. I don't want to put either page fields into the row or column fields as it would mess up my pivot chart. Is there anyway this issue could be solved or is there a VBA workaround. They have the option to exclude items with no data in the other fields, why not the page fields? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Field Items deleted when unchecked in Pivot table | Excel Discussion (Misc queries) | |||
| Pivot Table - Dragging multiple items into data field | Excel Discussion (Misc queries) | |||
| PivotTable - How to unhide page field items? | New Users to Excel | |||
| How do I count unique items in a pivottable data field. | Excel Discussion (Misc queries) | |||
| Excel Pivot Table Appends a '2' to the field data items | Excel Discussion (Misc queries) | |||
Threaded Mode
