View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
T. Jenkins T. Jenkins is offline
external usenet poster
 
Posts: 24
Default Pivot Table Value Filter

I'm trying to filter a pivot table to only process entries above a certain
dollar value. For example, I only want to act on data above $2M.

I know I could do this by sorting the original data by dollar value, then
only selecting records meeting my filter criteria, but I was hoping to do
this within the Pivot.

Any suggestions?

Todd