Pivot Tables - Adding Absolute Sum
 

My pivot table is showing me the Total Variance of my POSITIVE TOTAL
field and my NEGATIVE TOTAL field, and that's fine, but I also need the
Absolute variance. I don't care if the field is negative or positive, I
just want the unsigned total.

I can't get rid of the minus signs in my source data, because I still
need to show the total negative amount.

Thanks


--
ajpowers
------------------------------------------------------------------------
ajpowers's Profile: http://www.excelforum.com/member.php...fo&userid=9406
View this thread: http://www.excelforum.com/showthread...hreadid=531585

Pivot Tables - Adding Absolute Sum
 

You can create a calculated field, in the wizard select formulas and add a
field and assume that
the field you already using is called "Variance" then you can add a filed,
name it "Absolute" <g
then use the formula

=ABS(Variance)


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"ajpowers" wrote in
message ...

My pivot table is showing me the Total Variance of my POSITIVE TOTAL
field and my NEGATIVE TOTAL field, and that's fine, but I also need the
Absolute variance. I don't care if the field is negative or positive, I
just want the unsigned total.

I can't get rid of the minus signs in my source data, because I still
need to show the total negative amount.

Thanks


--
ajpowers
------------------------------------------------------------------------
ajpowers's Profile:
http://www.excelforum.com/member.php...fo&userid=9406
View this thread: http://www.excelforum.com/showthread...hreadid=531585