Pivot Table 2007 display field only in Grand Total
 

Dear Excel experts,

I have a Pivot Table (Excel 2007). As an example, the table consists of two
Colum Labels (Expense 1 and Expense 2). 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,
Management want to see Full Year Budget only in Grand Total (not under
Expenses 1 and Expense 2). I was manually hiding those values. Is there a way
to automate this?

Thanks