ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Calculate Difference between 2 columns in Pivot table (https://www.excelbanter.com/excel-discussion-misc-queries/70703-calculate-difference-between-2-columns-pivot-table.html)

Karen

Calculate Difference between 2 columns in Pivot table
 
I would like to know if the Pivot Table can calculate the difference between
two columns of data for me. For example, I have the amount of loans in
December in column A and the amount of loans in January in column B and I
would like to see the increase or decrease. THe way I've been doing this is
manually entering in the calculation.

Thanks in advance!

Dave Peterson

Calculate Difference between 2 columns in Pivot table
 
Debra Dalgleish explains lots at:
http://www.contextures.com/xlPivot10.html

Karen wrote:

I would like to know if the Pivot Table can calculate the difference between
two columns of data for me. For example, I have the amount of loans in
December in column A and the amount of loans in January in column B and I
would like to see the increase or decrease. THe way I've been doing this is
manually entering in the calculation.

Thanks in advance!


--

Dave Peterson


All times are GMT +1. The time now is 03:07 PM.

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