i have a pivot with 2 calculated fields, 1 is set as sum and 1 is set as average. i know what to create another calculated field to calculate =calculated field 1 (sum) -calculated field 1 (average). i've tried this, but it is calculating the average field as if it is a sum. for example 2%-10%(average)= should equal -8%, but it is calculating 2%-30% (sum) -28%. hope that makes sense?
Solved by X. J. in 19 mins