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
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?
Go to Solution.
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.
View solution in original post
Join us in the third Triple A event!
It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.
Make sure you didn't miss any of the things that happened in the community in January!