View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Debra Dalgleish
 
Posts: n/a
Default 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