Pie chart - Group together

[Anonymous]

Hello, I'm looking for a way to group together smaller enteties into a "other" category in pie chart

Here is a picture showing a portion of the data that is used as the input to the pie chart:

Here is what the pie chart looks now:

Here is what I want the pie chart to look like:

I would like the "three letter" codes that only appears once to be grouped together into a "other" category. 

[v-shex-msft · Accepted solution]

HI @Anonymous ,

I'd like to suggest you add a calculated column with if statement to manually replace specific types to 'other', then you can use this column on the pie chart to group your records based on new category.

Category =
VAR list = { "CAA", "EST", "FEX", "HJE", "JAU", "LGJ", "PAS", "SGT", "TRM" }
RETURN
    IF ( Table[Instructor] IN list, "Other", Table[Instructor] )

Regards,

Xiaoxin Sheng