Sort clustered column chart based on two levels: f...

Anonymous · ‎03-21-2023

I have a dataset that looks like below.

I'd like to create a clustered column chart that is sorted by bank with the highest count of total deals and then by year.

At the moment, my chart looks like the below.

The order should be Bank A (2019, 2021, 2022), Bank B (2019, 2020), Bank C (2021, 2022)

Is there a way I can do this?

Anonymous · ‎03-21-2023

Thank you Vicky. But I'm still having the same issue. I think the example I gave was bad because the deal in each year for each bank was the same.

What is the table had more deals for 2022?

How can you sort by total deal count for the bank and the year?

Eg.

vicky_ · ‎03-21-2023

You can put bank and year on the same x-axis. If the order is sorted incorrectly, click the three dots and check that it makes sense there

Sort clustered column chart based on two levels: first total deals by bank and then by year