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...
I've got a working sample of the horizontal bar chart based on the feedback in this thread - thank you all!
Now, I need to use similar logic to create a donut chart showing Top 5 else other, and other can shrink or grow (dynamic).
I've tried converting the logic in the bar chart, but so far haven't been successful.
Behavior shows - top 5, and then the first instance - the 6th - count instead of all (dynamic) counts >= 6.
If anyone has a working sample donut chart, that would be so awesome.
Thank you in advance,