Wondering if anyone knows how to add a row of subtotals to this chart to subtotal the Top 10? There are more columns but this should give you the idea:
I want to subtotal the numbers for the actual Top 10 and (ideally) not have the Remainder show as #9 when they are ranked.
I can move the totals to the bottom (they'd likely make way more sense there if the subtotals get added), but I cannot see any way to do this.