Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have the below table
Account | ID | Value | Typ | TDate | Grouping ID |
---|---|---|---|---|---|
Blue | 555 | 1500 | Open | 7/31/2018 | 1 |
Blue | 555 | -1500 | Close | 5/31/2018 | 1 |
Green | 444 | 1000 | Open | 6/30/2018 | 2 |
Green | 444 | -1000 | Close | 4/30/2018 | 2 |
Red | 333 | 500 | Open | 4/30/2018 | 3 |
Red | 333 | -500 | Close | 2/28/2018 | 3 |
Blue | 222 | 250 | Open | 3/31/2018 | 4 |
Blue | 222 | -250 | Close | 1/31/2018 | 4 |
I want the table to be sorted as above but I do not want to include the Grouping ID column. Does anyone have any suggestions as to how to do this?
Thanks,
Mark
Make your account dimension a dual, and it will sort on the numeric value:
=dual(Account, [Grouping ID])
Make your account dimension a dual, and it will sort on the numeric value:
=dual(Account, [Grouping ID])
Awesome thanks so much!