![]() |
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 |
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 |
All times are GMT +1. The time now is 12:21 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com