ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pivot Table Difference Columns (https://www.excelbanter.com/excel-discussion-misc-queries/232772-pivot-table-difference-columns.html)

Dave H

Pivot Table Difference Columns
 
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.


All times are GMT +1. The time now is 08:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com