Javascript Pivot Table JQuery Pivot Table Plugin + ASP.NET MVC Core integration

js pivot open-source jQuery pivottable.js plugin

• Lightweight, free and open source javascript pivot table: Pivottable.js (pivot.js)
• user-friendly drag&drop UI for creating pivot table (crosstab, summary table)
• handles up to 100,000 rows, all calculations are performed by js code
• supports typical aggregate functions: count, count unique values, list unique values, sum, average, min, max, % of totals; custom function can be easily added
• additional renderers: heatmaps, pivot charts (Google Charts / C3.js)

nreco extensions advanced features for pivottable.js

• fixed headers (freeze headers for pivot table rows & columns)^new
• sort pivot table by values, totals or labels
• drill down handler (click on cell and see aggregated data details)
• access to calculated pivot table data (for pivot table exports)
• Bootstrap 3 styles (can be upgraded to 5.x)
• ASP.NET MVC Core WebPivot Report Builder package includes:
  • PivotTable.js NReco Extensions (commercial version)
  • Data query builder js components (jQuery plugins)
  • NReco WebPivot Editor (integrates pivottable.js + NReco extensions with data query builder)
  • Server-side API for loading data by used-defined query from SQL database (based on NReco.Data library)
  • Export pivot table components (CSV, Excel, PDF)
  • Integrated ASP.NET example (MVC Core app, NET8):
    • use SQL database as data source for pivot table
    • server-side data filter: reduce amount of data for javascript pivot table
    • save / load pivot table report state (user-defined reports)
    • export pivot table to CSV/Excel/PDF formats
  • 1 year of email support and free package code updates

download and pricing

quick purchase process

• 1 Choose a package
• 2 Pay online
• 3 Download the package

how to use

1. Include jQuery, pivot.js and nrecopivottableext.js files
2. Initialize PivotTable jQuery plugin and apply NReco Extensions with the following js code:

   var nrecoPivotExt = new NRecoPivotTableExtensions({
   	drillDownHandler: function (dataFilter) { 
   		console.log(dataFilter); 
   	} });
   var sampleData = [{"A":1,"B":1,V:1}, ... ];
   var pvtOpts = {
   	renderer: nrecoPivotExt.wrapTableRenderer($.pivotUtilities.renderers["Table"]),
   	rendererOptions: { sort: { direction : "desc", column_key : [ "1" ]} },
   	vals: ["V"], rows: ["A"], cols: ["B"],
   	aggregator : $.pivotUtilities.aggregators["Sum"](["V"]),
   }	
   $('#pivot').pivot(sampleData, pvtOpts);
   

javascript pivot table example

frequently asked questions

what's new