Explain Customizing Pivot Grid Calculations | Syncfusion Blogs
Live Chat Icon For mobile
Live Chat Icon
Popular Categories.NET  (180).NET Core  (28).NET MAUI  (224)Angular  (113)ASP.NET  (49)ASP.NET Core  (81)ASP.NET MVC  (87)Azure  (41)Black Friday Deal  (1)Blazor  (234)BoldSign  (14)DocIO  (24)Essential JS 2  (110)Essential Studio  (199)File Formats  (72)Flutter  (135)JavaScript  (226)Microsoft  (121)PDF  (83)Python  (1)React  (105)Streamlit  (1)Succinctly series  (131)Syncfusion  (960)TypeScript  (33)Uno Platform  (3)UWP  (3)Vue  (46)Webinar  (53)Windows Forms  (59)WinUI  (72)WPF  (162)Xamarin  (159)XlsIO  (38)Other CategoriesBarcode  (5)BI  (29)Bold BI  (8)Bold Reports  (2)Build conference  (10)Business intelligence  (55)Button  (4)C#  (163)Chart  (145)Chart of the week  (57)Cloud  (15)Company  (440)Dashboard  (8)Data Science  (3)Data Validation  (8)DataGrid  (73)Development  (676)Doc  (7)DockingManager  (1)eBook  (99)Enterprise  (22)Entity Framework  (7)Essential Tools  (13)Excel  (43)Extensions  (23)File Manager  (7)Gantt  (20)Gauge  (12)Git  (5)Grid  (31)HTML  (13)Installer  (2)Knockout  (2)Language  (1)LINQPad  (1)Linux  (2)M-Commerce  (1)Metro Studio  (11)Mobile  (519)Mobile MVC  (9)OLAP server  (2)Open source  (1)Orubase  (12)Partners  (21)PDF viewer  (45)Performance  (13)PHP  (2)PivotGrid  (5)Predictive Analytics  (6)Report Server  (3)Reporting  (8)Reporting / Back Office  (9)Rich Text Editor  (12)Road Map  (12)Scheduler  (54)Security  (5)SfDataGrid  (9)Silverlight  (21)Sneak Peek  (32)Solution Services  (4)Spreadsheet  (11)SQL  (15)Stock Chart  (1)Surface  (4)Tablets  (5)Theme  (12)Tips and Tricks  (113)UI  (400)Uncategorized  (68)Unix  (2)User interface  (68)Visual State Manager  (2)Visual Studio  (31)Visual Studio Code  (19)Web  (624)What's new  (337)Windows 8  (19)Windows App  (2)Windows Phone  (15)Windows Phone 7  (9)WinRT  (26)

New White Paper Explains Customizing Pivot Grid Calculations

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.

Syncfusion’s newest white paper, “Calculation Customizations in PivotGrid Control,” discusses the different types of calculations supported in Essential BI PivotGrid. This includes special formatting, custom expressions, and custom summary calculations.This paper was coauthored by Syncfusion’s Suriya Prakasam R., the team lead for a number of BI products, and Clay Burch, Syncfusion’s director of technical support. Together they’ve collected samples that explain 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.

Each sample is demonstrative in the simplest, easiest-to-understand form, and all can be downloaded as .zip files. You can find this and other white papers at the Syncfusion Technology Resource Portal found at Syncfusion.com.


Share this post:

Popular Now

Be the first to get updates

Subscribe RSS feed