🍉 Meet Flexmonster Pivot Table & Charts 2.9.Check out all the hot features!
Get Free Trial

Layout Options

Sangamesh asked on August 27, 2019

Under layout options-> Grand Totals -> We need “Show for rows only” option to be enabled by default 
Under layout options-> Sub Totals -> We need “Show subtotal rows only” option to be enabled by default

1 answer

Vera Didenko Vera Didenko Flexmonster August 28, 2019

Thank you for writing to us.
You can enable the “Show for rows only” option for Grand Totals and the “Show subtotal rows only” option for Sub Totals by specifying the showTotals and showGrandTotals parameters in the grid options:

"options": {
"grid": {
"showTotals": "rows",
"showGrandTotals": "rows"

Here is a JSFiddle example for illustration: https://jsfiddle.net/flexmonster/f341cbnr/.
Please let us know if this works fine for you.
Best Regards,

Please login or Register to Submit Answer