Sorting Blank Value

[Anonymous]

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

[rsbin · Accepted solution]

@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,