View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Nicawette Nicawette is offline
external usenet poster
 
Posts: 27
Default Pivot table bottom ten filter with conditions

Hi

is it possible to have the bottom ten item of a pivot table but
excluding specific value(s)

eg I have a pivot table with the bottom 10 of cost

item 1 -200 $
item 2 -300$
item 3 -0$
....

I would like to exclude item that have a cost = 0$ and have only
items greater than 0.

thanks