Sort by Revenue for client & Year dimension on bar chart

[Bejiz]

Hi 

I am hoping you can please help me with an issue I am having with a bar chart I want to sort by the dimension created below

client_Year shows the client name and year as one dimension. I need the client to be sorted by highest revenue for 2022 followed by the previous year revenue for the same client. The below table and chart shows the example of the sorting order preference. Thank you.

clientYear	revenue
CLIENT A 2021	4,408
CLIENT A 2022	5,984
CLIENT D 2021	4,034
CLIENT D 2022	5,085
CLIENT C 2021	3,422
CLIENT C 2022	4,330
CLIENT B 2021	1,560
CLIENT B 2022	2,303

[Bejiz]

Hello just wondering if any experts have a solution to this problem please. Much appreciated thank you.