Calculate Difference between 2 columns in Pivot table

K

Karen

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

Calculation based on year of entry 1
Additional columns for Pivot table 0
Pivot Table - Row Label Combination 0
Slicers and Calculated Items in Pivot Table 2
Excel does not accept text format! 0
Consolidation Table from Different Excel Tabs with Different Format 1
Power Pivot Variance Column 0
List all tables, including document structure 0

Top