View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
richard
 
Posts: n/a
Default Pivot Table - report product that have sales above defined level

Hi,

consider an examle of data and a pivot table like in the page of famous jon:
http://peltiertech.com/Excel/Pivots/pivottables.htm, namely the most left
table in the third row.

I want to report all product that have sales above 8000. Other product i do
not want to see in the table.

I know how to report 3 best products but it is not i need.

Thank you

riso