Sorting dual y- axis combo chart

Good day,

I have been struggling with sorting my Dual y-axis combo chart. My graph shows the different employees and their actual production in the bar graph and their Bonus in the line graph. I would like to sort my graph in descending order.

I have conditionalised the colour of the bar chart to show whether bonus payments were made to an employee. Red the bonus payment is made and green the payment is not made.

When sorting the graph it groups the payments made and not made however, this defeats my purpose. I would like the graph to be sorted in overall descending order based off of my actual production and not group the payments and then sort them however this seems to be done automatically?

I have tried to add multi level sorting and it still gives me in correct sorting.

Please see screenshot of graph below. 

Thank you in advance.