Calculate Difference between 2 columns in Pivot table

G

Guest

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!
 

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

including zero values in a pivot table 2
PIVOT TABLE - HELP 1
pivot table. 2
How do I perform extended calculations in a Pivot Table in Excel 2 4
Finding a value in a multi-column table 3
Pivot tables Charts 2
Pivot table, IF function, calculated item versus calculated field 1
Pivot Tables, Grouping, and Calculations 1

Top