Hi guys,
Trying to work with the Pivot Table to create a difference formula.
It looks like this: = 'Impression #' - 'Targeted #'.
I have hundreds of data points for each of those varying from 0.0 to 123.0.
I'm looking for individual differences between the two points
The result, however, is a sum of the numbers.
Screen Shot 2014-07-16 at 4.47.55 PM.png
Does anyone know how to fix this problem?
I change the table to "Summarized by Sum, Count or Average" but it doesn't change the values of the new column at all.
The columns on the attached table are as follows: Impression #, Targeted #, and Difference.
Thank you everyone.
Bookmarks