Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Pivot Tables and Filter Criteria Display

Hi does anyone know how to display the filter criteria used on a pivot table ? (ie greater than X, or Top Ten...etc). I know there is a macro that does this for autofilters but it doesn't work on Pivot tables.

Ultimately, I would like to use this on a Pivot Chart so it clearly identifies how the data was filtered.

Thanks
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Link Pivot Tables on one filter steplawn Excel Discussion (Misc queries) 2 May 12th 10 09:33 AM
pivot tables value filter Tim Excel Discussion (Misc queries) 1 June 10th 09 05:10 PM
Can a cell display the filter & criteria of currentPivotTable Filt Karlerm Excel Discussion (Misc queries) 0 March 18th 08 06:51 PM
Pivot Tables - filter out zero's? Beccy Excel Discussion (Misc queries) 0 September 6th 07 03:14 PM
How can I DISPLAY Filter Criteria Scott Fendrich Excel Worksheet Functions 2 June 10th 05 08:15 PM


All times are GMT +1. The time now is 12:58 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"