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

      Hi

       

      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:

       

      ExampleImage.JPG

       

      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.

       

      Thanks

      Jenny