Pivot Table Hide Selected Field 2007

M

M Masalha

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top