Pivot table puzzle: "Top 10" for categorical data
I have a pivot table whose "Column" field is categorical data (say "A", "B", "C"). In the "Data" area I've added and customized two fields, one is the "Count of answer" (renamed), the other is "% of row" for "Answer" (also renamed). What I'd like to do now is to sort the data to show the top 10 folks based on their row % of "C" answers. For instance, those folks who answered all "C's" would definitely be shown. So I've been playing with the "Sort and Top 10" feature of pivot tables, but these seem to be based on summary statistics for the entire row. I'd like to sort based on a "% of row" within a particular value of a cateogrical varilable. Is this possible? Any hints would be most appreciated. FYI: visually the Pivot table looks like this: Answer Issue Data A B C Grand Total Abortion N 234 46 56 336 Percent 69.6% 13.7% 16.7% 100.0% Iraq N 167 16 41 224 Percent 74.6% 7.1% 18.3% 100.0% Migration N 144 24 56 224 Percent 64.3% 10.7% 25.0% 100.0% <... snip ... Thanks! / Tyla / |
All times are GMT +1. The time now is 10:10 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com