Hi!
We're doing a lot of pivots and would love to sort them by a column which is not visualized in the table itself (be it an ID of a value). The hiding of columns is possible in regular tables, but not in pivot tables.
See an example:
I do not want to use the ID column because it serves no purpose to the user, but without it I cannot achieve desired sorting in pivot table. See result without the column:
Is this being looked at? Are there any plausible workarounds?