Adding Calculating fields to pivot using "PercentageOfColumnTotal"

Question

I would like to use "PercentageOfColumnTotal" in a calculated field. Currently I get an error saying ' Invalid Formula'. When I try to add a new calculated field

Is there a different way of doing this?

Thanks in advance.

Manikandan Murugesan · Answer

Hi Thierry, 
 
Through code-behind and UI actions, the calculated field formula in the pivot table only supports the following aggregate types. And it will not consider any aggregate types other than the items listed below. Please refer the following screenshot below. 
 
Screenshot: 
  
 
For more information about the “Calculated Field” feature, please refer the UG document below. 

Document: https://ej2.syncfusion.com/javascript/documentation/pivotview/calculated-field/ 
 
Please let us know if you have any concerns. 
 
Regards, 
Manikandan