Pivot table bottom ten filter with conditions

  • Thread starter Thread starter Nicawette
  • Start date Start date
N

Nicawette

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
 
Back
Top