#1   Report Post  
Posted to microsoft.public.excel.misc
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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 389
Default Pivot Puzzle

Just to the right of the "total $sale" table header will be an arrow. Click
on it, and all values for total $sale will be displayed. Declick all less
than 2000.

"Wanna Learn" wrote:

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

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 318
Default Pivot Puzzle

The total $Sales column is in the data section of the pivot table so there is
no arrow

"Steven" wrote:

Just to the right of the "total $sale" table header will be an arrow. Click
on it, and all values for total $sale will be displayed. Declick all less
than 2000.

"Wanna Learn" wrote:

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

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,979
Default Pivot Puzzle

You can filter the total values in Excel 2007, but not in earlier versions.
For earlier versions, you start an AutoFilter outside of the pivot
table, and autoflter the total column for =2000.

Wanna Learn wrote:
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



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot table puzzle: "Top 10" for categorical data Tyla Excel Discussion (Misc queries) 0 April 6th 07 07:42 PM
A real puzzle? paulsuk Excel Discussion (Misc queries) 7 March 7th 07 07:27 PM
VLOOKUP puzzle ?? Anthony Excel Worksheet Functions 8 November 29th 06 05:49 PM
Excel Puzzle dwalesb Excel Worksheet Functions 2 January 26th 06 06:27 PM
Can you help!!!!! New Puzzle Krefty Excel Discussion (Misc queries) 0 June 13th 05 08:13 PM


All times are GMT +1. The time now is 04:10 AM.

Powered by vBulletin® Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"