I have created a sample dataset to try and explain my problem and hoping someone can help me.
I have sales date by Country, City and Status. And the output I'm looking to achieve is as below:
Using other posts I have been able to get the top N and sum of 'other', the problem I have in when I try and introduce the status in the column shelf as it does the top n for each status, and cannot add the grand total.
I have attached an example workbook.
Any help would be very much appreciated.