Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 / |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Make pivot table with multiple "data" fields in columns not rows? | Excel Discussion (Misc queries) | |||
Pivot Table - Remove "sum of" in data field | Excel Discussion (Misc queries) | |||
Pivot table "Show all data" query | Excel Discussion (Misc queries) | |||
Sorting "data" in pivot table | Excel Discussion (Misc queries) | |||
Changing data source in pivot table- "Back" button is disable | Excel Discussion (Misc queries) |