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

Pivot table bottom ten filter with conditions
 

Excel 2007 PivotTable
Bottom 10, no zeros.
Three ways.
http://www.mediafire.com/file/kd3dydo3ww4/01_31_10.xlsx

Pivot table bottom ten filter with conditions
 

thank you for the spreadsheet.