Thread: Pivot Puzzle
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Wanna Learn Wanna Learn is offline
external usenet poster
 
Posts: 318
Default Pivot Puzzle

Hello This is a daily report - I created a pivot table. The columns are as
follows companyname -sales order number - product description - product
number total $sale - I have a subtotal in the sales order number so that I
get a total for each sale. How do I delete all sales that total less than
2,000.00 - I want the pivot table to show sales of 2,000 and over only.
thanks