Thread: Pivot table: filter values great then, lower then...
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
  
Posts: 5,939
Default Pivot table: filter values great then, lower then...
Nope Top X or Bottom X. To do what you want you will need to add a helper
column to tyour source data which serves to flag the items you want...
--
HTH...

Jim Thomlinson


"Tomas" wrote:

So far I can only fitler TOP X pr BOTTOM X items of the pivot table, but I
would need to filter items i.e. greater then certain amount. Can this be done?
Reply With QuoteReply With Quote