Sort matrix table

[GKJARC]

Hi everyone,

I have a matrix table with a 2-level hierarchy (so two columns in the 'Rows' section): Customer name and Date.
Customer name is sorted alphabetically ascending.
Date I need sorted descending so that the latest date appears at the top.

So the desired sort order would be like this:

Customer name, Date
- Customer A
01-03-2024
01-12-2023
01-06-2023
01-10-2022
+ Customer B
+ Customer C

How can this be achieved?

Any help would be greatly appreciated.

Thanks!

[GKJARC]

Thanks @samratpbi for your reply.
I'm affraid my post lacked the important detail that the hierarchy can have up to 4 levels and only the first level should be sorted Ascencing, the others should sort Descending so the latest on top like this:

- Customer A
- A3
01-03-2024
01-12-2023
01-06-2023
01-10-2022
+ A2
- A1
01-06-2019
01-04-2019
01-03-2019
01-10-2018
+ Customer B
+ Customer C

[samratpbi]

Hi, I have created 1 sample table like below:

Then after putting values in a matrix visual, applied this sort option:

As you may see, Customers are asc and dates under a customer are desc.

If this resolves your proble, then please mark it as solution, Thanks!