Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table - Filtering Data Field
Excel 2003 - SP2
When I filter the data field Excel removes all the other data headings in the filter dialog box but those I kept so I can not filter back to those other headings. This does not happen for all the other fields I have tried - row and column. Any help would be appreciated. Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table - Filtering Data Field
Hi Mark
That is the way the PT works with Data. Row fields and Column fields you are actually choosing to Filter by. In the case of data, you are not filtering, you are selecting whether you want that field included as a data field or not. Once de-selected, you need to drag it back in from the field list to the data area. -- Regards Roger Govier "Mark" wrote in message ... Excel 2003 - SP2 When I filter the data field Excel removes all the other data headings in the filter dialog box but those I kept so I can not filter back to those other headings. This does not happen for all the other fields I have tried - row and column. Any help would be appreciated. Thanks. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table - Filtering Data Field
Thanks Roger. I am new to PT so this information helps. Maybe I can
organize my data differently in PT to get what I want (swap the row and data fields). Thanks again. "Roger Govier" wrote: Hi Mark That is the way the PT works with Data. Row fields and Column fields you are actually choosing to Filter by. In the case of data, you are not filtering, you are selecting whether you want that field included as a data field or not. Once de-selected, you need to drag it back in from the field list to the data area. -- Regards Roger Govier "Mark" wrote in message ... Excel 2003 - SP2 When I filter the data field Excel removes all the other data headings in the filter dialog box but those I kept so I can not filter back to those other headings. This does not happen for all the other fields I have tried - row and column. Any help would be appreciated. Thanks. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table - Filtering Data Field
Hi Mark
Fields in the data area are going to yield the numeric results that you want, be they Sum, Count Average etc. So, the fields containing that numeric data will have to be in the data area. A field can be added to the Row OR Column OR Page area, it can only be in any one of these at any time. But you can also add any filed that has been allocated to one of these areas ALSO to the Data area. It sounds as though you need to add them to both Row AND Data, then you can use the filter on the field in the Row area, without it being removed from the data area. -- Regards Roger Govier "Mark" wrote in message ... Thanks Roger. I am new to PT so this information helps. Maybe I can organize my data differently in PT to get what I want (swap the row and data fields). Thanks again. "Roger Govier" wrote: Hi Mark That is the way the PT works with Data. Row fields and Column fields you are actually choosing to Filter by. In the case of data, you are not filtering, you are selecting whether you want that field included as a data field or not. Once de-selected, you need to drag it back in from the field list to the data area. -- Regards Roger Govier "Mark" wrote in message ... Excel 2003 - SP2 When I filter the data field Excel removes all the other data headings in the filter dialog box but those I kept so I can not filter back to those other headings. This does not happen for all the other fields I have tried - row and column. Any help would be appreciated. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filtering Pivot Table Data | Excel Discussion (Misc queries) | |||
Filtering Pivot Table Data | Excel Discussion (Misc queries) | |||
Pivot Table Field Data | Excel Worksheet Functions | |||
Filtering data from one pivot table against another | Excel Discussion (Misc queries) | |||
Pivot Table - Filtering Page Field | Excel Discussion (Misc queries) |