Is it possible to add additional custom Total column next to Grand Total?

[desi shah]

Is it possible to add additional custom Total column next to  Grand Total?

[Sivamathi Natarajan]

Hi Desi Shah, 

 

Thanks for contacting Syncfusion support. 

 

The pivot table allows to edit the existing cells and allows to include additional columns/rows. And the grand totals are calculated based on the mentioned changes. But, couldn’t able to add additional column next to the grand total. This is the valid pivot behavior. 

 

Regards, 

Sivamathi. 

[desi shah]

Is there any way we can hide column and show only column at Grand total?

[Sivamathi Natarajan]

Hi Desi Shah, 

 

It isn’t applicable to include additional column next to grand total manually. But, with the help of calculated field option, you can create a new measure which will include additional column in grand total. Kindly refer the below UG for your reference.

https://ej2.syncfusion.com/angular/documentation/pivotview/calculated-field/  

 

Regards, 

Sivamathi. 

[desi shah]

ok, but I just want to show custom total in grand total area, so how can I hide custom column in item level area (in this case Year)? 

[Sivamathi Natarajan]

Hi Desi, 

 

Pivot Table has option to filter the members of specific fields in code behind. So, the selected fields alone will be displayed in UI. 

 

UG: https://ej2.syncfusion.com/angular/documentation/pivotview/filtering/#member-filtering  

 

If you would like to remove all the field members then you should remove the field from axis. This is the only possible option to meet the requirement. 

 

Regards, 

Sivamathi.