OLAP support with KPIs
The PivotGrid control comes loaded with full-fledged support for OLAP data sources featuring an OLAP browser. With its help, you not only get access to the data in an OLAP cube but also to the structure of the bound data source. The feature gives you the ability to extract multi-dimensional data insights and it enables drag-and-drop for all displayed fields, so that your report is completely customizable and matches your business analysis requirements. The accompanying Hierarchical Field List is fully optimized to load on demand the entire structure of the bound OLAP data source.
Layouts that fit your needs
Telerik's PivotGrid supports all of the three most widely used report layouts: Tabular, Outline and Compact. Use the Outline layout to see all the values such as a group descriptor, values and totals spread in separate columns and separate rows. The Tabular layout is very similar to the Outline however the group descriptors have no separate rows. The Compact layout keeps related data from spreading horizontally on the screen thus preventing end-users from endless scrolling. The fields at the beginning are displayed in the first column with certain indentation for better visualization.
Add and arrange fields in your PivotGrid report
The FieldList feature provides end-users with functionality similar to the PivotTable Field List panel in Microsoft Excel. It allows for a quick change in the way of the aggregated data representation in RadPivotGrid by an easy modification of the column/row group descriptions, the aggregate descriptions or the report filters. The end-users can do this by dragging fields across the five list boxes in the PivotFieldList or by reordering the items in a single list.
Quickly aggregate & summarize data
Add the initial aggregate fields to provide ready-to-analyze summarized data. Choose one of the common aggregate functions - sum, count, average, etc. aggregates, as well as any other Microsoft Excel supported custom function, like “StdDev” and “VarP”. Allow your end user to re-arrange the aggregate fields with a simple drag & drop. Set the position for the totals and the grand totals. Place them as first or last item no matter which layout your PivotGrid uses.
Sort, filter and group the way you like it
Want to have your data sliced by Country? Or you need to hide some of the countries? Group filtering will cover you. Employing easy-to-understand dropdown menus and dialogs, group filtering allows your end-users to achieve the exact data view they desire. What if your end-users don't need the country breakdown? Report filtering enables them to hide any specific field from the data representation with the help of a single drag & drop operation.