I'm not sure if I caught the subtleties,
but you could try a couple of different methods.
One is combining Book and Strategy into one field
and sorting that new field on Total, as described here:
Another method is to try a calculated field of
It would need the Table Calculation Settings to
be for all Specific Dimensions, restarting every Book.
Both these fields would need to be placed to the left of Strategy,
and then you could uncheck "Show Header".
Please see sheets Rank and Combined in the workbook v2018
attached in the Forum Thread.
275660rank.twbx 509.2 KB