cancel
Showing results for
Did you mean:
Highlighted
Regular Visitor

## Group waterfall chart in category "Other"

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Regular Visitor

## Re: Group waterfall chart in category "Other"

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.

Regular Visitor

## Re: Group waterfall chart in category "Other"

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.

Announcements