1 3 4 5 6 7 Previous Next 94 Replies Latest reply on Jul 25, 2019 8:28 AM by Helen Sandwick Go to original post Branched to a new discussion.
• ###### 90. Re: Top N, with everyone else as "Other"

Hi Experts,

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.

• ###### 91. Re: Top N, with everyone else as "Other"

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

https://onlinehelp.tableau.com/current/pro/desktop/en-us/sortgroup_sets_topn.html

• ###### 92. Re: Top N, with everyone else as "Other"

Thanks

• ###### 93. Re: Top N, with everyone else as "Other"

Hi Joe,

I tired your logic , but i want to calculate the percentage , instead of sum.

attaching the work book .

• ###### 94. Re: Top N, with everyone else as "Other"

Hi,

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,

Helen

1 3 4 5 6 7 Previous Next