1 Reply Latest reply on Sep 7, 2018 2:33 AM by Tushar More

    Top N and Sum other over N within category and include totals (v 10.5.1)

    Jenny Bomers



      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.