We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date
Syncfusion Feedback

Calculation Customizations in PivotGrid Control

Syncfusion’s PivotGrid control was deliberately constructed as a business intelligence tool. Its inherent design provides in-depth analysis and concise summaries of complex data. As is, it supports a variety of calculations, but with minimal effort it can also be a powerful platform for custom calculations.

In this white paper, coauthors Suriya Prakasam R. and Clay Burch explain the different types of customizations that allow users to display various summary calculations in Syncfusion’s PivotGrid control.

The white paper provides downloadable samples illustrating how to:

  • Use a single DateTime property as a year or month pivot.
  • Use expression fields to dynamically create a new calculation field based on other calculation fields already bound to the pivot grid.
  • Implement custom summary calculations, walking through a median calculation as an example.