Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table - Drop down choices
Good afternoon all,
Does anyone know if it is possible to have a "custom" filter (one that contains choices like "is greater than","begins with", etc) included in the drop down choices in a pivot table? In my Pivot Table, I want to have choices like I do when I use a regular Data Filter (in the top menu). If yes, please advise how. Thank you very much, Hugues Quesnel |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table - Drop down choices
That feature may be available in future versions of Excel, but not in
Excel 2003 or earlier versions. Filtering in Excel 2007 pivot tables is described he http://blogs.msdn.com/excel/archive/...20/506172.aspx Hugues wrote: Good afternoon all, Does anyone know if it is possible to have a "custom" filter (one that contains choices like "is greater than","begins with", etc) included in the drop down choices in a pivot table? In my Pivot Table, I want to have choices like I do when I use a regular Data Filter (in the top menu). If yes, please advise how. Thank you very much, Hugues Quesnel -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pivot table | Excel Discussion (Misc queries) | |||
Pivot Table Drop Down Boxes | Excel Discussion (Misc queries) | |||
Pivot table, dynamic data formula | Excel Discussion (Misc queries) | |||
Pivot Table Problems | Excel Discussion (Misc queries) | |||
How do I remove items listed in a pivot table drop down list box | Excel Discussion (Misc queries) |