Pivot Table - filtering 'row' and then hide it
 

Hi,

I have 'hours worked' as a row in a pivot table. I use the drop down arrow
to filter/deselect the data I don't want, everything is fine and the totals
are adjusted correctly.

Lets say I only want the PT to show 'hours worked' 10. So I deselect what
I don't need (everything <10). I now know this PT to be 'hours worked
greater than 10' but I don't want to see each instance of 'hours worked'
10.5, 11.75 etc etc , just the totals by department (dept is also in data).
But when I (right click and) hide the column it reverts back to the grand
total of ALL 'hours worked'. Is there a way I can filter the required data
and then hide it and retain the correct/filtered totals?

Thanks in advance,

AW