If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|