Sorting a straight table based on expression via a button

[#1]

I have a simple straight table with a 'name' dimension and then a calculated numeric value currently sorted by the expression in numeric order ascending. I need to be able to allow users to sort in ascending/ descending order via a button in the same way as double clicking on the row header controls the interactive sort on a straight table but needs to be via variable/button. I can only sort the dimension via an expression so not sure if this is possible.

Any ideas? Thanks

[Anonymous]

You can use a conditional expression, where the condition is defined by a variable, and the variable is defined by a button.

But - what's wrong with dbl-clicking???

[anguila · Accepted solution]

You can use a variable to change the sort order, using the sort by expression in the straight table:

Order by click:

I attach you an example.

Regards,

[#4]

Thanks David..Just the job!! I'd nearly done that myself but hadn't altered the sort priority. Users don't want column headings on table so cant double click

Thanks

Gavin

[vikasmahajan]

good one

Vikas