May I ask: what kind of Subtotals are you expected to see,
taking into account [SP Code] claimed to be Unique ID? Just curious.
Sorry for delay in revert.
What I wanted is the subtotal of both GWP & % Share of GWP of Top 10 SPs. just below the bars.
So you just want Column Grand Totals
for your Top 10 [SP Code] by SUM([GWP]) ?
This is as simple as placing [SP Code] on Filters
and choose ALL --> Top 10 by SUM([GWP]).
Then show Column Grand Totals.
Please make sure every other dimensions
on Filters are in Context.