Forum Discussion
Sorting Blank Value
The goal is to have a blank value anchored at the bottom of a table. Scenario for context: orders can be placed and will be sit in a queue until assigned to an employee. If an order has not been assi...
Anonymous ,
Please see if this works for you. Create a Calculated Column:
Sort Order = SWITCH( TRUE(), Sort[Employee ] <> BLANK(), RANKX(Sort, [Orders Assigned],, desc), 99 )You can change the 99 to a higher number if you need to.
EmployeeOrders AssignedSort Order
Michael Jordan 23 2 Steph Curry 12 3 Luka Doncic 11 4 Zach Levine 9 5 100 99 Then use the "Sort by Column" tool to sort [Orders Assigned] by [Sort Order]
Regards,
Anonymous ,
Please see if this works for you. Create a Calculated Column:
Sort Order = SWITCH(
TRUE(),
Sort[Employee ] <> BLANK(), RANKX(Sort, [Orders Assigned],, desc),
99 )You can change the 99 to a higher number if you need to.
EmployeeOrders AssignedSort Order
| Michael Jordan | 23 | 2 |
| Steph Curry | 12 | 3 |
| Luka Doncic | 11 | 4 |
| Zach Levine | 9 | 5 |
| 100 | 99 |
Then use the "Sort by Column" tool to sort [Orders Assigned] by [Sort Order]
Regards,