PDA

View Full Version : Pivot Table Calculated Field to Assign Scores



troh3178
2016-04-18, 03:37 PM
Hi! I'm trying to assign a scoring system to a set of percentages in a pivot table. I'm running into problems when there is a roll-up (one person has multiple results rolling up to them). How do I get the calculated field to read the roll up value and assign the score? The formula in the calculated field is

= IF('Qualtiy Average' >0.95, 5, IF('Qualtiy Average' >0.9, 3, 1))

I have a roll up average of 89%, and its scoring it a 5.

If it's not possible with the calculated field, any other suggestions?

Thanks for any assistance!

Herbds7
2016-04-18, 09:53 PM
Excel 2010 with free Power Query Add-In.
Compatible with Excel 2013/2016.
For more help, see this book:
"The Excel Guide to Power Query" by Ken Puls
http://www.mediafire.com/download/rawz6gchxsqc9s6/04_18_16a.xlsx
http://www.mediafire.com/download/jmcqmt0du8bc8q6/04_18_16a.pdf (http://www.mediafirehttp://www.mediafire.com/download/jmcqmt0du8bc8q6/04_18_16a.pdf.com/download/rawz6gchxsqc9s6/04_18_16a.xlsx)

Pecoflyer
2016-04-20, 05:33 PM
@Herbds

Hi

please post your files on the forum instead of an external link. This deprives many members of an answer as not everyone is authorized to access those links. Thank you