Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-15-2012, 12:01 PM
uhlersa uhlersa is offline Pivot Table Windows XP Pivot Table Office 2007
Novice
Pivot Table
 
Join Date: Mar 2011
Posts: 9
uhlersa is on a distinguished road
Default Pivot Table


I have a pivot table created with three items 1st is by machine, 2nd is by description, 3rd is by hours. I then have the pivot table sorted by highest hours. My want is to eliminate everything in the table under an hour. Does anyone know how to do that? This is excel 2007. In the old one you were able to go to the value field settings and select greater than or less than. That option is gone in 2007. Any help would be greatly appreciated.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot table help TishyMouse Excel 2 04-27-2012 10:19 AM
Pivot Table pivot table aliasadi_07 Excel 1 03-11-2012 12:49 AM
Pivot Table Help with a pivot table please! natsha Excel 1 02-16-2012 12:41 PM
Pivot Table Pivot Table Karen615 Excel 5 08-03-2011 10:46 AM
Pivot Table Refresh tpcervelo Excel 0 09-14-2010 06:54 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:29 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft