Pivot Table (Excel 2007) Display Full Year Budget Field only in Gr
 

Dear Excel experts,

I have a Pivot Table (Excel 2007). The Table consists of two Column Labels
(Expense1 and Expense2). Values under the Column Labels are Actual Expense,
Budget and Full Year Budget.

All Values (Actual Expense, Budget and Full Year Budget) are totaled in the
Grand Total. However, I need to display the Full Year Budget field only in
Grand Total (not under Expense1 and Expense2).

I was manually hiding those values.

Is there a way to automate this?

Regards
M Masalha