Back to forum

How To hide Grand Total Columns

Resolved

i want to hide Grand Total in my Columns, by default setting. anyone can help me ?

Attachments:
webdatarocks.png

4 answers

WebDataRocks Team WebDataRocks November 20, 2018

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

Osama Baraja November 23, 2018

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

Attachments:
webdatarocks 2.png

WebDataRocks Team WebDataRocks November 23, 2018

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

Osama Baraja November 28, 2018

Thank You very much, it’s work

Move up