1. Feedback
  2. JavaScript
  3. 50652

Welcome to the JavaScript feedback portal. We’re happy you’re here! If you have feedback on how to improve the JavaScript, we’d love to hear it!

  • Check out the features or bugs others have reported and vote on your favorites. Feedback will be prioritized based on popularity.
  • If you have feedback that’s not listed yet, submit your own.

Thanks for joining our community and helping improve Syncfusion products!

0
Votes

Improve the calculated field formula for the pivot table

In general, the pivot table's calculated field calculations are performed using the brackets "()" in the formula to identify the chosen field and its aggregation type (for example: '"Count(Sold)" + "Sum(Amount)"'). Therefore, when we provide a data source to the pivot table and the containing fields have brackets "()", we are unable to do calculations for the calculated field. And this is because we are unable to obtain the specified field from the formula expression since selected brackets play a key role in obtaining the field name from the formula and will not be replaced with another special character at this time. Thus, we need to update the calculated field formula structure by allowing users to change the bracket () in the formula expression. Using this delimiter, the calculated field formula should do its calculations in the pivot table.