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.
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: