LISTAGG, change sorting of result with reference to another column

1

Same question as sql - LISTAGG, change sorting of result with reference to another column - Stack Overflow

however, seems

SELECT LISTAGG("item", ', ') WITHIN GROUP (ORDER BY "Desc") "item"
FROM tableA;

is not working in Dremio, with error message

ORDER BY columns must be subset LISTAGG columns

I have some workarounds to use combination of CAST, CONCAT and ROW_NUMBER() OVER to preserve the order. Any simpler way to achieve the same result?

Thanks.