Freezing the header row for a pivot table
Is there any way to freeze the header row in a pivot table, when the number of rows is very high it is difficult for users to scroll up and see what each column refres to
Hi datanerd ,
If I was starting with a new dashboard with 0 widgets, in order to get the header to scroll I noticed I needed to toggle off "Auto Height" and adjust the widget size to match how much space in the dashboard I wanted the widget to take up.
For Sisense running on Linux, the setting looks like this:
I could then adjust the height of the widget
And the scroll bar on the right side of the widget appears with the header being pinned as I scroll through. Keep in mind there will be a scroll bar for the widget but also a scroll bar for the whole dashboard - it is worth considering when designing your dashboard how much dashboard space the widget should take up.
The settings on Sisense Windows looks like this:
Attached is a zip folder containing videos showing how I got this working on both Linux and Windows.
Hope this helps!