Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
Hello just wondering if any experts have a solution to this problem please. Much appreciated thank you.