Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
jenn
 
Posts: n/a
Default show only > 9 in a pivot table

Hi, This is my very first pivot table experience. I have my pivot table
showing only names and the sum of hours for each name. How do I show only the
name with the sum of hours when the sum is 9?
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

Not a pivot table expert but one way would be to add the heading for the hours
assume you have the names header in the rows and the hours in the data, you
can go back to the wizard and drag the hours header to the column, then in
the dropdown from the hours the hours should be in ascending order, uncheck
everything 9 hours and below

Regards,

Peo Sjoblom

"jenn" wrote:

Hi, This is my very first pivot table experience. I have my pivot table
showing only names and the sum of hours for each name. How do I show only the
name with the sum of hours when the sum is 9?

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
How do I show summary totals from a pivot table on a bar chart Colleen T Charts and Charting in Excel 5 January 22nd 05 01:41 AM
Pivot Table services Craig Excel Discussion (Misc queries) 5 January 19th 05 06:11 PM
Pivot Table - Group by Month - Show Items with no data Dan Reynolds Excel Discussion (Misc queries) 0 November 28th 04 01:01 AM
Pivot Table "Show All" Check Box missing in Excel 2000 OwenLiu Excel Worksheet Functions 2 November 8th 04 11:43 PM
Problem with Pivot Table Drop-Down Menus Mac Excel Worksheet Functions 4 November 7th 04 01:18 PM


All times are GMT +1. The time now is 01:37 PM.

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

About Us

"It's about Microsoft Excel"