Thank you for sharing. I had seen that thread and noticed that they wrapped the LISTAGG in an EVALUATE function. My organization has the EVALUATE_SUPPORT_LEVEL parameter in the NQSCONFIG.INI file turned off as mentioned here and unfortunately they won't turn it on:
Now I could go to the RPD and execute this but not everyone in my organization has access to the RPD and that is why I'm looking for a way to order in Answers. Currently in the Criteria tab we have columns similar to the one created below:
LISTAGG("Table Name"."Column Name" by "Employee"."Emplid")
In this same Edit Column Formula in the Critera tab in Answers can I order this LISTAGG in any way by "Column Name"?
With this being a custom column in Answers this is the first selection step executed if that is helpful.
Thanks again for your time. Much appreciated.