none
Calculated field in Pivot table RRS feed

  • Question

  • Hi, I have a set of data on students' acceptance to college and I would like to calculate the acceptance rate for each college that they applied.  The database has the field of status with either "accept", "not accept" or "waitlist" populated.  Each record also has the college name as well as the score of students' SAT scores, GPA and subject scores. I would like to create a calculated field where I can use a formula of "acceptance rate=accept/(not accept+waitlist)". The online help that I've found tells me that I would have to have different columns identifying "accept", "not accept" and "waitlist" but my data are laidout in the same column.  Is there way I don't have to convert the existing data while still able to create such a calculated field?  Thanks.
    Thursday, January 12, 2012 6:51 PM

Answers