Please help. Matrix visual - Sort by count and extra column

[ylebec]

Hi,

The table below is sorted by the total count of instances associated to a certain duty number. In addition, I need to sort within the duties by Start Time ascending, i.e. for Duty W1421 Start Time 1010, 1050, 1210, 1250 and 1330.

 

How can I do it? The count of instances will get updated on a daily basis... can I use Rank here?

Regards

[ylebec]

Any help please? I can't find anything similar around...

[v-shex-msft]

HI @ylebec,

You can click on '...' icon to choose sort field.(current only support row fields and value fields, you can't direct modify sort order of column fields.)

BTW, current you can't set up sort by multiple columns.

Regards,

Xiaoxin Sheng