I found a way to add “SUM” formula then auto fill to the rest of the rows
But i have got another problem when trying to sort the “SUM” by Descending order.
The result did not return properly. See below:
My expected result is as below (figures show in proper descending order, so that I can process next step):
My workflow as enclosed. May I see if i have made any mistake there and pls help to advice any possible way to solve this
Top_10.zip (89.4 KB)