Pivot table has no scroll bar for right(vertical) side

[guanghao fan]

There's no scroll bar for the right side in the Pivot Table. So, the experience is not good if the data is very tall. Can we add an option to show the vertical scroll bar for Pivot Table?

[Stiltsoft support]

Hi @guanghao fan ,

Please define the app that you are using - there is no any Pivot Table macro out-of-the-box.

We develop the Table Filter, Charts & Spreadsheets for Confluence app that also provides the Pivot Table macro among many other macros.

So, if this is the case, you may insert the Table Toolbox macro as you are on Cloud and create the following macro sequence inside its shell: source table <- Pivot Table <- Table Filter. The Table Filter macro will be used to set pagination for your aggregated pivot table.

[guanghao fan]

Hi @Stiltsoft support 

Here is the link of the pivot table:

Pivot Table

what I did is to create a pivot table from a normal table. So, I want a vertical scroll bar if the pivot table is a very tall table.

See below pivot table, it has bottom scroll bar, but no for vertical inside the table. Do you think is it good for view? 

Another thing we can't freeze the header or the columns. 

Pivot Table

Pivot Table is one of the macros bundled in the Table Filter, Charts & Spreadsheets app. The macro allows you to summarize your table data and produce its aggregated view in the form of a pivot table. You can select the appropriate operation types as follows:

[Stiltsoft support]

Hi @guanghao fan ,

To freeze a header (columns), place the Table Filter macro on top of the Pivot Table macro and follow the guide: https://docs.stiltsoft.com/tfac/cloud/sorting-freezing-hiding-columns-and-other-table-viewing-options-42239875.html#Sorting,freezing,hidingcolumnsandothertableviewingoptions-FreezefirstNrows/columns

Please note that on Cloud you need the Table Toolbox macro to nest macros. On Data Center it can be done directly on the page.