Pivot Tables - Adding Absolute Sum

A

ajpowers

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
 
P

Peo Sjoblom

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
 

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 and variance calculation 1
Pivot Table % Variances 0
Pivot Table exclude negative values from sum 2
Pivot Table Variance 2
Problem with Calculated item in Pivot Table 1
Absolute value 2
calculating variances in pivot tables 3
Pivot table grand total location 1

Top