3 Replies Latest reply on Jun 29, 2016 9:04 AM by Shinichiro Murakami

    Help with Top N+ Others on subgroup level (for each region)

    Kamila Jerabkova

      hi all,

       

      we were trying to modify following example (Top n RL with condense option.twbx, attached bellow) found here on the forum for Top N including Others. We would like to add Region as grouping and get Top N+ Others Customers for each region.

       

      output for eg. for top 2 should look like this:

      Region | customer |Sales

      Region 1| A| sum of sales for cust. A

      Region 1| B | sum of sales for cust. B

      Region 1| Others | sum of sales for cust. other then A and B

      Region 2| C | sum of sales for cust. C

      Region 2| D | sum of sales for cust. D

      Region 2| Others | sum of sales for cust. other then C and D

       

      Does someone has experience with it, can anyone help please?

      Thanks