default

Progress Telerik UI for WPF

WPF PivotGrid

  • Sorting and Filtering

    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).
    Sorting and Filtering
  • Grouping

    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.
    Grouping
  • Editing capabilities

    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. 
    Telerik UI for WPF PivotGrid Editing Gif
  • 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.
    Layouts and Totals Position
  • Aggregate Functions

    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.
    Aggregate Functions
  • Calculations

    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.
    Calculations
  • 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.
    Pivot Ragged Hierarchy in PivotGrid for WPF and Silverlight
  • Support for KPIs

    PivotGrid supports KPIs, so you can use the ones defined on the server and easily measure performance.
      Support for KPIs
  • OLAP Support

    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.
    OLAP Support
  • Tooltips

    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.
    PivotGrid ToolTips
  • PivotFieldList

    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.
    PivotFieldList
Get Started Waves

Next Steps

Launch demos

See Telerik UI for WPF in action.

Check pricing

Purchase individual products or any of the bundles.

Download 30-day free trial

With dedicated technical support.