#### Chris The Rock

##### Active Member

- Joined
- Feb 24, 2002

- Messages
- 287

The calculation for Customer Satisfaction (CSAT) is the total number of Q1 responses that are 4 or 5, divided by the total number of Q1 responses.

I can do this easily by creating a pivot table and doing some calculations outside of the pivot table. I can also add on to the data and create new fields to help me calculate this also.

I'm just wondering if it's possible to write a formula for a pivot table calculated field that will do it. I just have trouble with the syntax, since formulas for calculated fields don't work the same way that worksheet functions do.

None of the educational material I've seen deals with this kind of situation. I use calculated fields all the time, but not in the type of situation where I need to use IF/AND functions.

I am using Excel 2010.

Thanks in advance.