Forum Discussion

datanerd's avatar
datanerd
Cloud Apps
04-21-2022
Solved

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!

2 Replies

Replies have been turned off for this discussion
  • KatieG's avatar
    KatieG
    Sisense Employee

    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!