“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

pivot table calculated field is not working in excel Help

Solved by G. C. in 18 mins

I need to make a calculated field in a pivot excel table comparing the same field for two different sales people.

Solved by M. B. in 30 mins

I am trying to insert a calculated field into a pivot table but the Analyze > Fields, Items, & Sets > Calculated Field... is grayed out. Is there a work around for this?

Solved by I. D. in 21 mins

I have a problem regarding to Working with a Calculated Field in an Excel Pivot Table

Solved by T. F. in 19 mins

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