Forum Discussion
sort column with duplicate values by another column
I want to sort the account column based on the sort column.
In the report, users would single-select from the report column {1, 2}. Based on the selection, accounts would be sorted differently.
| report | account | sort |
| 1 | account1 | 1 |
| 1 | account2 | 2 |
| 1 | account3 | 3 |
| 2 | account1 | 1 |
| 2 | account2 | 3 |
| 2 | account3 | 2 |
Obviously, it is not possible to simply sort account columns based on the sort column, but is there a trick to achieve the end result mentioned above?
I would like to use the original account names if possible (no ragged values).
2 Replies
Hi akos_skutovics ,
According to your description, here are my steps you can follow as a solution.
(1) My test data is the same as yours.
(2) We can create a table.
Table 2 = {1,2,3}(3)Sort in ascending order with [sort] columns and then the result is as follows.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you for your reply Anonymous,
1) Sorting doesn't really work for me, since I would like to present the accounts in various ways where adding a sort measure as you presented is not an option.
2) Could you please explain why your solution is better than just taking the 'sort' column from the first Table
