Pivot Table Calculations

K

Kirk P.

How do I add a pivot table calculation that will show me the difference
between value fields over a particular column label?

In this case, the column label is SOURCE, which has 2 fields, platform and
ePEN. I'm trying to get the difference between platform and ePEN for various
values, something like:

SOURCE
PLATFORM EPEN
ORDER_COUNT ORDER_COUNT DIFF
SITE_ID 1131 10 9
1
255 35 40
-5
 
M

Maria Lara

Hi, where do I find the Insert Calculated Item option?
and where do I pick it on the pivot table?
 

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

Dealing with a Pivot Table (when I don't want to) 0
Countifs or a pivot 1
Pivot Table - Row Label Combination 0
Additional columns for Pivot table 0
Slicers and Calculated Items in Pivot Table 2
pivot table missing rows? 0
pivot table calc item 8
Pivot Table Difference Columns 0

Top