sorting legend based on two criteria
I have a simple dataset that contains each supplier's sale in each year. I made a bar chart with years in the x axis and suppliers' sale on the y axis and used supplier company as legend. I want to sort the legend (suppliers) in each bar (year) based on the total sales of that supplier in that specific year. I can sort them by all-time total sales of suppliers, but I dont know how to do this sorting in each year.
