Welcome to the Forums.
Well done on the worksheets, quite a lot of moving parts.
It is pretty much all there, I think it needs just a few tweaks:
1. To get the top chart to sort descending percentages:
a. Changing Sort of [Rank] to "Data source order"
b. Changing Sort of [Data] to "Sort by" and "Field: Number of Records" and "Aggregation: Sum" and "Sort Order: Descending"
2. To get bottom charts to sort:
a. Changing [Rank] to work on the Sum of records: RANK_UNIQUE(SUM([Number of Records]))
3. To get the bottom sheets for all Questions
a. Adding [Question super wording] to the Detail Shelf of sheet practice2c
b. Editing the Show-Hide Filter to add to "Target Filters" to add the Filter of [Question super wording]
I may have missed some things, but I hope the attached can be a first step to solving.
Would be happy to try and explain aspects further, if needed.
209300visrank.twbx 2.5 MB
Thank you so much, and for sending the example file! This works.