Freezing the header row for a pivot table

[datanerd]

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

[KatieG · Accepted solution]

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!

[NT_Sisense_Adm]

HI Is there a way to freeze members/dimensions of pivot chart