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 assigned to an employee, it is just blank. Below is sample data along with current output + expected output.
Your support is greatly appreciated.
Current Output (notice Employee = "Blank" / Orders Assigned = 100)
| Employee | Orders Assigned |
| 100 | |
| Michael Jordan | 23 |
| Steph Curry | 12 |
| Luka Doncic | 11 |
| Zach Levine | 9 |
| Total | 155 |
Expected Output (notice Employee = "Blank" / Orders Assigned = 100)
| Employee | Orders Assigned |
| Michael Jordan | 23 |
| Steph Curry | 12 |
| Luka Doncic | 11 |
| Zach Levine | 9 |
| 100 | |
| Total | 155 |
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,
1 Reply
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,