View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mit05 mit05 is offline
external usenet poster
 
Posts: 2
Default Pivot table "restricted" output

Hi,
In the row area I have the fields Product, Country and Month.
In the data area I have the fields Sales_Act (Sum of) and Sales_Bdg (Sum of).
How can I get in pivot table the only products, countries and monthes that
have Sum of Sales_act between $ 9,000 and $ 40,000?

Thanks