Combining Rows in a graph

[roxys373s]

Hello,

I was wondering if it was possible to combine two bars on a bar graph - the chart below is my graph and I want to combine the last five bars into one. How can I do this? 

[sidhiq91 · Accepted solution]

@roxys373s  Can you please try the below expression in your Dimension in Bar chart.

=if(match([Dimension],'TRES'),'TRES',
if(Match([Dimension],'MBS1','DIST','GINY','AGEN','SBAL'),'Others'))

I mentioned all the 5 dimension values as others, you can mention them as per your need.

If this resolves your issue please like and accept it as a solution.