PivotGrid allows you to apply sorting on your rows and columns. Naturally, the sorting can be ascending or descending, but in addition to that, PivotGrid gives you the ability to sort based on totals. You can also apply different filters to hide/show specific groups or use one of the three filter types: Label filter (filters data by header name), Value filter (filters data by aggregated values), Top 10 filter (filters by aggregated values, but shows only top/bottom results).
PivotGrid makes access to OLAP cubes easy. You can choose between our XmlaDataProvider and AdomdDataProvider depending on your server connection needs. In combination with PivotFieldList you can easily visualize data from your Cube. You can also apply filters or sort the data to view only the items you need.
Use PivotFieldList to provide your users an easy runtime customization of the PivotGrid reports. You can easily add fields to the report, or drag fields between different areas. You can use integrated dialogs to modify each aspect of PivotGrid.
Use calculations to further analyze the aggregated data by comparing the cells to each other. For example, for each cell you can: compute the percentage of the GrandTotal, compute the difference from its previous or next one, calculate its weighted average, etc., and help you discover its relative importance.
Group records in an assigned data source according to row and column descriptors, based on the selected fields in row and column areas. Apply sorting on your rows and columns, as well as different filters to hide/show specific groups.
Download 30-day free trial
With dedicated technical support.
See UI for WPF in action.
Purchase individual products or any of the bundles.
Copyright © 2017, Progress Software Corporation and/or its subsidiaries or affiliates. All Rights Reserved.
Progress, Telerik, and certain product names used herein are trademarks or registered trademarks of Progress Software Corporation and/or one of its subsidiaries or affiliates in the U.S. and/or other countries. See Trademarks or appropriate markings.