I have followed the steps to calculate top x and others however I found one issue.
The top part is showing correct data but Others are not summing up correctly.
Means, sum(sales) should sum up for rest of the others firm.
Can anyone please advise?
there should be no issues, it should work perfectly...
ensure that sum table calculation is done with Table Down option... if not please publish your workbook
also try this method...