Forum Discussion

DXC's avatar
DXC
Cloud Apps
09-23-2025
Solved

How to increase the display more rows in Pivot Table?

Hi,

we have a need to display multiple rows in a pivot table widget, but it appears that there is a limit at 20, as the screenshot below the plus disappeared when reached to the limit. 

Is there a way allows to add more rows? 

 

dashboards & reporting
  • MikeGre's avatar
    MikeGre
    09-25-2025

    Hi DXC​ 

    Try the script below on the widget:

    widget.manifest.data.panels.forEach(function(p){

    p.metadata.maxitems = 70; //replace with the number you need

    })

    Works on L2024.3! :) 

2 Replies

  • gwolfe's avatar
    gwolfe
    Data Pipeline
    09-23-2025

    Yeah you can change this as an admin.

    Admin -> System Management -> Configuration -> pivot table 

     

  • MikeGre's avatar
    MikeGre
    ETL
    09-25-2025

    Hi DXC​ 

    Try the script below on the widget:

    widget.manifest.data.panels.forEach(function(p){

    p.metadata.maxitems = 70; //replace with the number you need

    })

    Works on L2024.3! :)