Hi, I want to make a pareto chart and I have some data with one column showing category and other values. But I want to put the rows with value greater than 85% in OTHER column. The sum of the OTHER column is greatest among all so it is appearing as the 1st bar but i want it at the last.
And how to make it dynamic i.e. how it will automatically put rows with value greater than 85% in OTHER column.