![]() |
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! |
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