Pivot Table Hide Selected Field 2007
 

Dear Excel experts.

I have a Pivot Table (Excel 2007). The table reports monthly expenses,
monthly budget numbers and full year approved budget by product (example,
pens, books, computers, etc.). There is a calculated total field to add all
numbers (monthly expenses, monthly budget and full year approved budget) for
all products (pens, books, etc.). I am trying to report the full year budget
only near the total of all products. I.e. report monthly expenses, monthly
budget by product and report full year budget only for the total of all
products. If I remove the full year budget field from the pivot table, the
field will be removed from all products and total. Is there a way to remove a
field from products and display the full year budget only at the Total
(Currently, I am manually hiding the full year budget field for each product).

Thanks
M Masalha