Sorting x-axis by filtered Sales Value while drilled down

Hello everyone, first time for me to ask for help here, but I really stumbled upon this problem that I am not able to solve. I have a Sales table with columns Date, Customer, Department, Product,...