Whats New in 2018 Volume 4 : JS Pivot Table Updates | Syncfusion Blogs
Live Chat Icon For mobile
Live Chat Icon
Popular Categories.NET  (181).NET Core  (28).NET MAUI  (227)Angular  (113)ASP.NET  (49)ASP.NET Core  (81)ASP.NET MVC  (87)Azure  (42)Black Friday Deal  (1)Blazor  (236)BoldSign  (14)DocIO  (24)Essential JS 2  (110)Essential Studio  (200)File Formats  (73)Flutter  (136)JavaScript  (226)Microsoft  (122)PDF  (83)Python  (1)React  (105)Streamlit  (1)Succinctly series  (131)Syncfusion  (964)TypeScript  (33)Uno Platform  (3)UWP  (3)Vue  (46)Webinar  (53)Windows Forms  (59)WinUI  (72)WPF  (163)Xamarin  (159)XlsIO  (38)Other CategoriesBarcode  (5)BI  (29)Bold BI  (8)Bold Reports  (2)Build conference  (11)Business intelligence  (55)Button  (4)C#  (164)Chart  (147)Chart of the week  (58)Cloud  (15)Company  (440)Dashboard  (8)Data Science  (3)Data Validation  (8)DataGrid  (73)Development  (681)Doc  (7)DockingManager  (1)eBook  (99)Enterprise  (22)Entity Framework  (7)Essential Tools  (13)Excel  (43)Extensions  (23)File Manager  (7)Gantt  (21)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  (522)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  (112)UI  (406)Uncategorized  (68)Unix  (2)User interface  (68)Visual State Manager  (2)Visual Studio  (31)Visual Studio Code  (19)Web  (628)What's new  (341)Windows 8  (19)Windows App  (2)Windows Phone  (15)Windows Phone 7  (9)WinRT  (26)

What’s New in 2018 Volume 4: JavaScript Pivot Table Updates


We are happy to announce that our JavaScript Pivot Table has been updated to its final version. In this blog post, we are going to explore the following major features included in this 2018 Volume 4 release:

  • Editing
  • Drill-through
  • Additional aggregation types
  • Defer layout update
  • Hyperlink
  • Show/hide grand totals and subtotals

Final version of the Pivot Table and new features are also available in Angular, React, Vue, ASP.NET Core, and ASP.NET MVC.

Editing raw items

Editing helps users when applying predictive analytics to their instinct value. Our JavaScript Pivot Table allows you edit raw items directly in a flat/data grid. Users can create, read, delete, and update a record in the raw data source for any pivot summarized cell. In the editing operation, the engine automatically recalculates the pivot data and reflects that change in the JavaScript Pivot Table.

Double-click any pivot cell and it will show a built-in dialog with raw data for the corresponding pivot cell. Double-click any cells in the flat grid from the built-in dialog to edit the data. When you finally update the edited data, the pivot table engine will automatically recalculate the pivot data and reflect it in the view.

There are four types of editing options: inline, batch, dialog, and column. For more details, refer to the documentation.

Cell editing in the JavaScript Pivot Table


Drill-through is a powerful feature used for analysis perspective that provides the ability to see data in a detailed manner. In other words, it shows the raw data of any aggregated value.

You can view the raw items of any pivot cell by double-clicking the cell in the JavaScript Pivot Table. The built-in dialog will be opened. It holds the row headers, column headers, and value information of the clicked cell along with raw data. Refer to our documentation for more details.

Drill through in JavaScript Pivot Table

Advanced aggregation types

We have provided additional aggregation types for better analysis of business data in different scenarios. Newly included types are distinct count, product, index, population stdev, sample stdev, population var, sample var, running totals, difference from, % of difference from, % of grand total, % of column total, % of row total, % of parent total, % of parent column total, and % of parent column total.

We have also provided an option to change the aggregation type through UI interaction for every measure item in the grouping bar and pivot table field list. It helps users change the aggregation type dynamically. Click here to view our documentation on changing the aggregation type.

Advanced aggregation types in JavaScript Pivot Table

Defer layout update

In general, pivot users experience problems while working with big data, as each report operation takes additional time to update the pivot table. To avoid this, we have introduced a defer layout update option to refresh the JavaScript Pivot Table on-demand, similar to the Microsoft Excel pivot table.

When users try to remove or add multiple fields in a report, they may encounter the pivot table updating after each change. But now, users can update the pivot table after performing all changes in the report for a better experience. Users can easily enable or disable this option with UI provision in the field list. Refer to this link for documentation.

Defer layout update in JavaScript Pivot Table


Users can navigate to the desired page or perform custom operations with cell information when clicking a hyperlink cell.

Users can avail themselves of various options to enable hyperlinks for specific cells. Hyperlink options can be applied for all cells, row headers only, column headers only, value cells only, summary cells only, condition-based options, and for specific row/column headers. Click   to learn more about hyperlink settings.

Hyperlink support in JavaScript Pivot Table

Show hide totals

We have provided an option to display a JavaScript Pivot Table without any grand total or subtotals. Similarly, users can avoid any specific row/column grand total or subtotals for a specific field.

Totals can be disabled by setting an API in the pivot report, and the pivot table will render the data without calculating the total cell. For more details, refer to the documentation.

Show or hide sub-totals and grant totals

What’s Next

If you are an existing customer, please download the new version from the download page and try this new widget and its features for yourself. If you are a new customer, you can try our 30-day free trial to experiment with this new widget.

Please let us know in the comments section below if you have any questions. You can also contact us through our support forum or Direct-Trac.

If you like this post, we think you’ll also enjoy the following:


Share this post:

Popular Now

Be the first to get updates

Subscribe RSS feed