Sort Pivot Table by percentage of parent column total

Copper Contributor

Hello,

 

I have created a pivot table and chart and I am having trouble sorting the results by percentages. The pivot table contains a row for people and a row with a yes or no designation. For the "yes or no" column I have added in the value fields setting to summarize values by count and to show values as % of Parent Column Total. That has resulted in the correct results (a column for percent of yes and a column for percent of no and each connected to the corresponding row.  The problem that I'm having is that now that I have done that I cannot sort by the % of no or the % of yes. I have tried so many different sorting options I have lost count. I've attached a screenshot so you can see what I mean.

1 Reply