When using pivot table widgets, sometimes you need to use columns that the end user does not need to see, for different purposes:
- sorting data
- avoiding grouping of values
- passing values to filters that affect other widgets.
We consulted Sisense and several links and scripts were provided. However, we noticed that if the pivot table contains both row and value columns, the value columns might not display correctly - depending on the column width. See attached screenshot.
We believe the ability to hide columns in pivot tables should be a standard and basic feature and hope to get enough support so that this gets prioritized.