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).
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.
The PivotGrid component can be extended to allow UI editing of the cells values, which in turn will raise a notification that allows for data recalculation. This is useful in cases where you want to test how different input will translate to.
Layouts and Totals Position
PivotGrid supports all of the three most widely used report layouts: Tabular, Outline and Compact. You can set each of them on your rows and your columns, and in this way achieve nine different views of PivotGrid. And if this is not enough, you can also rearrange where the row/column totals positioning is located from the top, bottom, right, left or none.
Enjoy several predefined aggregate functions that you can use for your data. Choose between sum, average, count, max, min, or something more complicated like standard deviation, variance or product. All of this is done in the easiest possible manner – just one line of code or a couple of clicks with PivotFieldList.
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.
Ragged Hierarchy Support
RadPivotGrid provides yet another option for easy data summarization and visualization. Use the Ragged Hierarchy support for RadPivotGrid to represent user-defined hierarchies with an uneven number of levels.
Support for KPIs
PivotGrid supports KPIs, so you can use the ones defined on the server and easily measure performance.
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.
PivotGrid shows ToolTips for each cell. Just move the mouse over a cell, and you will see information about its value and associated aggregate, row, and column. You can also set your own ToolTips or simply disable them.
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.