Group waterfall chart in category "Other"

[rodfernandez]

Hi,
I have the following problem,
I need to group all the categories of the waterfall chart that are not in the 90% of the total value,
for example, I have the following data

Column 1	Column 2
A	10
A	12
B	15
C	9
B	8
B	5
A	4
C	10
D	2
E	1
F	1
G	3
H	1

The 90% of the Total (81) is 72.9, so only B, A and C should show as individual categories and G, D, E, F and H should show like "Other". Like this

Is there any way to do this without messing with de data?

[Edna]

Microsoft should simplify the solution, lookerstudio is a good example of how to make things simpler and user friendly. 

[Anonymous · Accepted solution]

Hi rodfernandez

I would approach this with a calculated column to identify if the category in column 1 of that record should be displayed as Other or the current category. so

Plot Type = if(calculate(sum(Table1[Column 2]),filter(Table1,Table1[Column 1] = earlier(Table1[Column 1]))) > sum(Table1[Column 2])*.1,[Column 1],"Other")

Then use Plot Type as the category for your waterfall chart.