i want to hide Grand Total in my Columns, by default setting. anyone can help me ?
Hello, Osama!
Thank you for writing to us.
This kind of customization can be easily achieved with the help of the Options object.
To hide grand totals from the grid, just set a grid.showGrandTotals
property to "off"
.
You can find all the ways to change the grid and general options of the pivot table in our documentation:
https://www.webdatarocks.com/doc/options-object/
And you are welcome to try our demo if you have any difficulties in changing the options:
https://codepen.io/webdatarocks/pen/EOogbm
You can hide subtotals as well by setting a showTotals
property to "off"
. Please check the following demo:
https://codepen.io/webdatarocks/pen/oQBYGy
Hope it helps.
Regards,
WebDataRocks Team
Hallo WebDataRocks,
Thank you for your response. I have tried using the samples provided. but not what I want. I just want to hide the total column (Total Sum) and not eliminate the Grand Total at the bottom of the grid.
To be clearer, how can I set the default for Grand Total according to the attach file that I gave.
Regards,
Osama Baraja
Hello Osama,
Thank you for your explanation.
Just set a grid.showGrandTotals
property to 'columns'
.
Here’s a CodePen demo with the functionality you’ve described.
Please let us know if it helped you.
Regards,
WebDataRocks Team
Thank You very much, it’s work