•I am building a report in Excel 2010 that uses external data and has multiple pivot tables created from that data.
•My pivot tables each have a sub total field.
•Each of the subtotal fields are aggregating 4 different values.
•One of the value fields is $/hr and is therefore not suitable for aggregation.
•I can't find a way to remove the subtotal on this field. If I make it a row label instead of a value I loose the values.
•The data is dynamic and changing with refresh so I can't just delete or reformat the values.
•Simplied version looks like this:
Resource--------Resource Type------Project--------------Bill Rate ($/Hr)------------- Total Effort (Hrs)----------Cost ($)
Jackson---------Internal---------------Aba Prj--------------100---------------------------76----------------------------760
Jackson---------Internal---------------Baba Prj------------100---------------------------42----------------------------420
Jackson---------Internal---------------Caba Prj------------100---------------------------81----------------------------810
Jackson Sub Total--------------------------------------------300-------------------------199-------------------------1,990
The 300 number in bold red is what I need to hide or delete. This is dynamic data that will change numbers of rows, etc. up refresh.
THANKS!
Bookmarks