Custom sort in staright table

[PreranaLH]

Hi i have table below with Risk as dimension and other as Expression.

I want sorting by Inherent/Residual col - by custom sort (it should be H-M-L)

i am trying to put match(Inherent,'H','M','L')in Sorting tab but dont know why the option is disabled .

even i tried removing # col - which is showing Rowno()

[JordyWegman]

Hi Perana,

Try to give it a Dual() value. Dual means that you can give 1 field, both a numeric and text value. This way you can sort easily.

match(Inherent,Dual( 'H', 1 ), Dual( 'M', 2 ), Dual( 'L', 3) )

Jordy

Climber

[PreranaLH]

thank u 🙂

just realized that we can use Dual for sorting

but can i give Numbering for each row"#" col . as sorting is not working properly if i keep that col