Sort formatted values in Wave table

[shamilh2o]

Hey team,
I am looking to sort values displayed in a table column.
I am passing the values as integers and the type of column is defined "number".

data_type="number"

But if I want to display values in comma separated format as below I have to pass the value as a string. Then the sorting doesn't perform as expected.

wave version 0.26.2

I am looking to give better feeling to the user with comma separated format for lengthy values same time allowing them to sort it.
Any existing solution which I missed or suggested workaround for this?

Thanks!

cc: @mturoci

[mturoci]

For custom sort (and other custom table actions), use server side table which allows custom sorting, filtering, searching etc.