You create a crosstab that shows a list of 100 hotel chains alongside their average nightly cost. You also create two groups showing, respectively, the top 10 and bottom 10 hotel chains by cost, with subtotals.
What should you do to improve the crosstab and compare the two groups to all the remaining hotel chains?
To improve the crosstab and compare the top 10 and bottom 10 hotel chains by cost to all the remaining hotel chains, you should include an 'Other' group. This allows you to aggregate and compare the average nightly costs of these specific groups against the rest of the hotel chains, providing a clear comparison between the highlighted groups and the overall dataset.
C is most logical
The Answer : C
https://help.tableau.com/current/pro/desktop/en-us/sortgroup_groups_creating.htm
C: Include an Other Group. https://help.tableau.com/current/pro/desktop/en-us/sortgroup_groups_creating.htm