Pivot Table Difference Columns

D

Dave H

I have searched but haven't found the answer. I have a pivot table with
2 columns 2007 and 2008. I want a column to show the difference between
the two. I have added the sum of amount to the Values field. set up
the difference. Everything works perfectly except that I get a column
for the difference between 2007 and 2007 as well as the 2007 and 2008.
How do I remove the 2007 column in the pivot table? My table actually
has quite a few columns each with 2007 and 2008 so manually removing
them is not an option.

Thanks for any help.
 

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

Similar Threads

Pivot table problem 4
Setting column width in a table with a macro is not working 0
Dealing with a Pivot Table (when I don't want to) 0
Dates In Excel 5
Pivot Table Counting Text Data 0
Pivot Table Calculates the Difference in Grand Total 2
Additional columns for Pivot table 0
Pivot Table - Show difference 6

Top