You're very close to the answer. I've put some additional function to get the output using WINDOWS_MAX()
Drag the fields as per instructions. Let me know If you've any query.
Workbook 9.3 attached for your reference.
Client Desc.twbx 8.5 KB
Exactly what I needed, and it worked!
The only question is, why does this work? Does window_max rank strings above null values?
Table calculations are using both addressing and partitioning.
WINDOWS functions aggregates the inner measure across the addressing dimensions and returns a result for each address in the partition.
Read this thread for more details about how windows function works in tableau.
Hope this help.
Sent from my iPhone