ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pivot Table - Drop down choices (https://www.excelbanter.com/excel-discussion-misc-queries/93174-pivot-table-drop-down-choices.html)

Hugues

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

Debra Dalgleish

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