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

pivot table calc item 8
pivot tables - number of columny but need a column for each month 2
How do I perform extended calculations in a Pivot Table in Excel 2 4
Pivot Table Variance 2
Pivot Table - Show difference 6
Countifs or a pivot 1
Pivot table problem 4
OLAP Pivot Table Calculations 4

Top