Remove Grand Total Row and Column

[Valeria de la Torre]

Hi,

For my project I need to remove both the grand total column at the bottom and left ends of the table.

Is there a way to do it??

[AngelinFaithSheeba PaulvannanRajadurai]

Hi Valeria,

You can show or hide grand totals in rows and columns using showGrandTotals property in the pivot table. Please refer the below code example and demo sample.

Code Example:

this.dataSourceSettings = { 

       showGrandTotals: false

 };

Demo Sample: https://ej2.syncfusion.com/angular/demos/#/bootstrap5/pivot-table/summary-customization

Document: https://ej2.syncfusion.com/javascript/documentation/pivotview/summary-customization/#show-or-hide-grand-totals

Also, You can also show or hide grand totals in rows and columns dynamically using built-in toolbar options. Please refer the below sample and documentation.

Sample: https://ej2.syncfusion.com/angular/demos/#/bootstrap5/pivot-table/toolbar

Document: https://ej2.syncfusion.com/javascript/documentation/pivotview/summary-customization/#show-or-hide-totals-using-toolbar

Regards,

Angelin Faith Sheeba.

[Valeria de la Torre]

Thank you Angelin!! It worked just fine!

[AngelinFaithSheeba PaulvannanRajadurai]

Thanks for the update. Please contact us if you have any other queries. We are always happy to assist you.