T
Tyla
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 /
"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 /