1
1
Often I am creating pivot tables that summarize some count by some category. Let's say I am counting Yes/No responses by some category. I usually add the count field and display it as a "% of row", and then create a pivot chart. However, if I want to sort one of the columns, say "Yes", Excel sorts by the underlying count, not the calculated percentage. Any way around this?
mindless.panda
Posted 2010-03-18T18:57:20.340
Reputation: 6 642
Can you give a specific example? – Rhys Gibson – 2010-03-22T08:22:37.383
Where can I host pics to post? – mindless.panda – 2010-03-22T14:40:27.737
1
See http://meta.stackexchange.com/questions/26365/is-there-a-way-to-attach-images-to-a-question
– Rhys Gibson – 2010-03-23T04:14:27.490@mindless.panda Did you ever figure out how to post pictures? :P – Engineer Toast – 2016-01-28T21:40:02.997