Sorting a pivot table and data outside of the table

Attached I have a workbook that explains exactly what I'm trying to accomplish. I need to sort columns A and B in the pivot table, but I also want to sort column C which is outside of the pivot table but is a serious of averages tied to the pivot table data. Is that possible? Thanks in advance!

You may replace the formulas - add the Name field a second time to the data area and then right-click and choose to Show Values As, % of Column. You may then sort the pivot table however you wish.

Thank you both!