Despite the COVID-19 outbreak, our team continues operating at full speed. We are always here to support and answer all your questions.

Feel free to reach out by filling this quick form.

Fill the form
Get Free Trial

Remove subtotals when doing grand total on columns.

Answered
Nagaraj Chatiri asked on November 10, 2019

There should be an option to exclude Sub Totals if flexmonster as user want for grand total only and no intermediate/sub totals between the report.
screenshot attached the sub total row is highlighted in yellow. 

Attachments:
grandtotalexclude.PNG

1 answer

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster November 12, 2019

Hello, Nagaraj,
 
Thank you for reaching out to us.
 
Our team kindly recommend checking out an options object:
https://www.flexmonster.com/api/options-object/.
 
It’s property showTotals allows displaying or hiding totals.
 
If you want to hide subtotals from your grid, simply embed the following construction to the report object:

"options": {    
"grid": {
"showTotals": "off"
}
}

 
The user is able to show or hide subtotals using UI by default, but it seems you have changed something in the layout pop-up menu. We recommend checking on the reason which entailed the loss of subtotals settings.
 
Check out the default view with our demo: https://www.flexmonster.com/demos/pivot-table-js/
 
We hope it helps.
 
Regards,
Illia

Please login or Register to Submit Answer