- Aggregate multiple dimensions
- Sort, group and filter dimensions on the left/top axis
- Sortable generated columns
- Lock/unlock left axis columns
- Group rows/cols and expand/collapse the groups
- Different layout views: outline and compact
- Positioning for totals and grand total: first, last or none
- Supported aggregation functions: sum, avg, min, max, count or a custom function
- Plugins: export to excel, configurator, drill down, range edit
- RTL support
- Compatible with ExtJS 4.1.x, 4.2.x and 5.0.x framework
Patrick Vandersluis, PhD
Our company has been developing complex software for over two decades and had the opportunity to evaluate many third party products. I can sincerely say that mzSolutions is the most responsive vendor we have ever worked with. In using their outstanding product mzPivotGrid, we have found the developers to be very attentive to our specific use case for the module and they have incorporated features to meet our needs nearly immediately. We are a team of very experienced developers and were delighted to find the code for mzPivotGrid to be extremely well designed and implemented, therefore very easy to extend to our needs. If you are in the ExtJS development family and want to let your users develop reports from your data, you will find this to be a tool you can’t be without. MzSolutions has shown a commitment to keep the product completely in tune with the latest release of ExtJS.
mzPivotGrid opened lots of new possibilities to build more comprehensive interfaces for our BI systems. We also recommend it because of the awesome technical support.
MzPivotGrid is the best tool to use in PivotTable and OLAP application!! Ability to provide information to our customers with its beauty and functionality as well . In addition, MzPivotGrid has an efficient support and it's ready to attend new features. This is a great tool. I recommend!
Putting together multi-dimensional data and creating cubes and other database-side stuff is easy enough. The real problem we had was to provide users with a good way of exploring the dataset. After a lot of searching, mzPivotGrid provided us with the perfect solution. We have found the control to be perfect as a browser-based user control to expose our multi-dimensional data. The control is well-designed and works with ExtJS as if it was a native control making very good use of Ext’s model and store classes. The API is great as well, providing control at the right level. And to top it all is the great personalized support and updates demonstrating a real commitment for the product. I fully recommend this product.
(Note: This endorsement has been provided in the personal capacity of the individual and does not constitute an endorsement of any kind by the United Nations Office for Project Services or any other United Nations body.)
Arun Kirthi Cherian
We were looking for a pivot toolkit for our benchmarking enterprise application that fit well into the EXTJS framework, and Mzpivotgrid is a perfect fit. It has enabled our customers to better visualize their data, and apply appropriate filtering logic to slice and dice it as they need. This is a must-have for anyone looking for pivot table functionality with full Ext JS framework support.
mzPivotGrid enables us to release app that cater what our customer need, with a clean and polished look and feel. Service response time, accuracy and helpfulness are excellent. I would highly recommend mzPivotGrid simply for the high quality of service I've experienced.