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.