Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
2003 Pivot Table Filter (items dropped in the Page Fields)
I have some data that I want to filter by months in a pivot table. I dropped
the data, and it is working to my needs except that I can't pick month ranges in the filter at the top (the data dropped in the "Page Fields" area of the pivot). I want to be able to look at both month ranges that differ in length, what happens in even months. Basically, what I'm asking is: Is there a way to allow multiple selection of the filter fields on a pivot table? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
2003 Pivot Table Filter (items dropped in the Page Fields)
Hi Sean
In Excel 2003 you can only do it by "cheating". Place your Months in a Row filed areaSelect the months you wantdrag the Months back to the Page area where it will show Multiple Selection as the heading. -- Regards Roger Govier "SeanF74" wrote in message ... I have some data that I want to filter by months in a pivot table. I dropped the data, and it is working to my needs except that I can't pick month ranges in the filter at the top (the data dropped in the "Page Fields" area of the pivot). I want to be able to look at both month ranges that differ in length, what happens in even months. Basically, what I'm asking is: Is there a way to allow multiple selection of the filter fields on a pivot table? __________ Information from ESET Smart Security, version of virus signature database 4510 (20091015) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 4510 (20091015) __________ The message was checked by ESET Smart Security. http://www.eset.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pivot table - drop down filter box has 10% of items out of order | Excel Discussion (Misc queries) | |||
Specifying the order of pivot table calculated fields/items | Excel Discussion (Misc queries) | |||
Remove grouped items and fields from pivot table | Excel Discussion (Misc queries) | |||
How to increase calculations speed in pivot table with calculated fields & items | Excel Discussion (Misc queries) | |||
How do I set up filter for page fields in pivot table? | Excel Discussion (Misc queries) |