Super Fast Pivot Analysis
Analyze enterprise data faster - much faster.
DevExpress Pivot Grid control is built for speed. With its in-memory Data Processing Engine and greatest performance, you can process and summarize enormous volumes of data at incredibly fast speeds. The PivotGrid gives the highest possible performance to its data processing and crosstab reporting features, including aggregations and window functions.
See how DevExpress Pivot Grid compares to the competition and why we think it has no equal in the marketplace. Feel free to download our newest release and put the Pivot Grid's data processing engine through its paces.
Microsoft Analysis Services (OLAP)
Leverage multi-dimensional data analysis.
The Pivot Grid control fully supports Microsoft Analysis Services (OLAP) cubes. When bound an OLAP cube, the PivotGrid automatically delegates all data management and calculations to the server. Supported data providers include: OLEDB for OLAP, ADOMD.NET, and XMLA.
DevExpress PivotGrid also includes the following data analysis options:
- OLAP Drill Down
- OLAP KPI (Key Performance Indicators)
- Calculated OLAP Fields (MDX)
Data Filters
Locate information with multiple search tools.
Filtering is the basic feature used to quickly highlight data you want to draw attention to. The Pivot Grid includes comprehensive set of filtering and custom query options:
- Excel Inspired Filtering
- Query Builder / Filter Criteria Editor
- Custom Filter UI
- Filter Panel & Most Recently Used (MRU) Filters
- Comprehensive API / Create Custom Filters
Conditional Formatting
Highlight values for maximum data clarity.
The Pivot Grid ships with Microsoft Excel inspired Conditional Formatting. This powerful feature allows you to highlight cells/rows based on a certain criteria without writing a single line of code. Cells/rows can be highlighted with data bars, icons, and predefined color scales. At runtime, users can easily create and apply style conditions by activating the Pivot Grid's popup menu.
Shape & Analyze Pivot Data
Deliver personalized UI for in-depth data analysis.
Big data is only helpful when it is accurately and effectively analyzed. With its powerful data architecture, our WPF Pivot Grid is able to slice and dice information efficiently and intuitively present it to end-users. The Pivot Grid delivers a myriad of data shaping and aggregation options, including:
- Automatic Summaries (Average, Count, Max, Min, Sum, and Var) / Custom Summary
- Window Calculations & Custom Expressions
- Automatic Totals / Custom Totals / Running Totals
- Multi-Field Sorting & Top N
- Sorting / Data Grouping / Interval Grouping
- Drill-Down