Sort Pivot Table by percentage of parent column total

%3CLINGO-SUB%20id%3D%22lingo-sub-2333574%22%20slang%3D%22en-US%22%3ESort%20Pivot%20Table%20by%20percentage%20of%20parent%20column%20total%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2333574%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20created%20a%20pivot%20table%20and%20chart%20and%20I%20am%20having%20trouble%20sorting%20the%20results%20by%20percentages.%20The%20pivot%20table%20contains%20a%20row%20for%20people%20and%20a%20row%20with%20a%20yes%20or%20no%20designation.%20For%20the%20%22yes%20or%20no%22%20column%20I%20have%20added%20in%20the%20value%20fields%20setting%20to%20summarize%20values%20by%20count%20and%20to%20show%20values%20as%20%25%20of%20Parent%20Column%20Total.%20That%20has%20resulted%20in%20the%20correct%20results%20(a%20column%20for%20percent%20of%20yes%20and%20a%20column%20for%20percent%20of%20no%20and%20each%20connected%20to%20the%20corresponding%20row.%26nbsp%3B%20The%20problem%20that%20I'm%20having%20is%20that%20now%20that%20I%20have%20done%20that%20I%20cannot%20sort%20by%20the%20%25%20of%20no%20or%20the%20%25%20of%20yes.%20I%20have%20tried%20so%20many%20different%20sorting%20options%20I%20have%20lost%20count.%20I've%20attached%20a%20screenshot%20so%20you%20can%20see%20what%20I%20mean.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2333574%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2339977%22%20slang%3D%22en-US%22%3ERe%3A%20Sort%20Pivot%20Table%20by%20percentage%20of%20parent%20column%20total%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2339977%22%20slang%3D%22en-US%22%3E%3CA%20href%3D%22https%3A%2F%2Fyoutu.be%2Frz_HtD2kelM%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fyoutu.be%2Frz_HtD2kelM%3C%2FA%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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