Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a problem in sorting data in a table according to my 'taste'.
The table has names and values and two of the names are 'other' and 'blank'. They both have a value.
So, if I sort Alpha by name, they can be placed at the bottom using Wildmatch, but then the value order is not respected. If I sort via value, it's obvious they won't be at the bottom.
is there a way to achieve this?
How it is
Name | Value |
---|---|
A | 100 |
B | 120 |
C | 90 |
D | 180 |
--- | 30 |
Other | 200 |
How I'd like it
Name | Value |
---|---|
D | 180 |
B | 120 |
A | 100 |
C | 90 |
Other | 200 |
--- | 30 |
Thanks
You can add Sort by Expression to Name, and get those results using the following expression:
if(Name = 'Other', -1,
if(Name = '---', -2, Value))
You can add Sort by Expression to Name, and get those results using the following expression:
if(Name = 'Other', -1,
if(Name = '---', -2, Value))
Works smoothly !!!
thanks