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)

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

• 1. Re: Help with Top N+ Others on subgroup level (for each region)

To all the calculated fields in the side window, and all the fields used in the sheet which uses table caluculation, add advanced table calculation as below.

Thanks,

Shin

9.2 attached.

• 2. Re: Help with Top N+ Others on subgroup level (for each region)

hi Shin,

thank you very much for your answer! It looks good, but problem is that we would need top N based on SUM, not on Average.  I thought it would be an easy change but if I update "Top N or Other Sales" variable to be SUM instead of AVG to look like this

, it is producing incorrect values for Others and also it is not picking up the correct top people. see example bellow. I realized it was even the case with the original file without Region grouping - average numbers were fine, but sum was giving weird numbers

Here is what should be the correct result for the top 9 for Central (I dragged the field to new sheet and then sorted it by Sales)

but in the sheet it looks like this:

Thanks, Kami

• 3. Re: Help with Top N+ Others on subgroup level (for each region)

Not sure exactly, but either of below two works?

Thanks,

Shin