topic Custom sort in staright table in App Development

Custom sort in staright table

PreranaLH — Tue, 20 Apr 2021 02:52:27 GMT

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 — Tue, 20 Apr 2021 05:50:41 GMT

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 — Tue, 20 Apr 2021 06:07:50 GMT

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