Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
How to set multiple filter values for a filter in the page fields
Hello all
I have a filter on a time dimension I want to use time on the page fields and still set the filter on different quarters. When time is in a row or a column of the pivot table I can restrict and set multiple filter values but when I move this time dimension to the page field I loose the ability to set multiple filter values can of you please suggest work arounds on how to accomplish setting multiple filter values in the page fields of a pivot table. Your help is highly appreciated. Thanks Simon |
#2
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
How to set multiple filter values for a filter in the page fields
There are some instructions he
http://www.contextures.com/xlPivot03.html#Page Simon Lenn wrote: I have a filter on a time dimension I want to use time on the page fields and still set the filter on different quarters. When time is in a row or a column of the pivot table I can restrict and set multiple filter values but when I move this time dimension to the page field I loose the ability to set multiple filter values can of you please suggest work arounds on how to accomplish setting multiple filter values in the page fields of a pivot table. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
filter multiple values | New Users to Excel | |||
2003 Pivot Table Filter (items dropped in the Page Fields) | Excel Discussion (Misc queries) | |||
Advanced Filter for blank fields in multiple rows | Excel Discussion (Misc queries) | |||
Pivot table page filter not accepting multiple values. Workaround? | Excel Worksheet Functions | |||
How do I set up filter for page fields in pivot table? | Excel Discussion (Misc queries) |