•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!