Get Free Trial
Get Free Trial

Remove subtotals when doing grand total on columns.

Answered
Nagaraj Chatiri asked 4 days ago

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 2 days ago

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