Get instant live expert help on I need help with excel calculated field
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
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