Ability to unset column sorting

[lovincyrus]

It's common to have tri-states in table design: unset, ascending, descending.

Is your feature request related to a problem? Please describe. The current pivot table allows users to toggle between ascending and descending sort orders by clicking on a column header. However, clicking a different column header resets the sort order of the previously sorted column. We should allow users to unset a column on the third successive click.

https://github.com/user-attachments/assets/d6fcebe6-9f6b-42cc-bde4-5363ca2c82cb

Describe the solution you'd like Allows users to easily toggle between ascending, descending, and unset states by simply clicking on the column header.

Additional context Check the sorting example from Tanstack: https://tanstack.com/table/latest/docs/framework/svelte/examples/sorting

Code reference Search for enableSortingRemoval in the codebase.

[lovincyrus]

Is the column sorting intentionally limited to only ascending and descending options? Would you have any context? @jkhwu @djbarnwal @ericpgreen2

[jkhwu]

I think unsetting a column sort would be a helpful feature and I don't know of any reasons why we don't offer this already. Let's move forward with this, thanks!