The UWP pivot grid control organizes and summarizes business data and displays the result in a cross-table format.
The UWP Pivot Grid performs long-running operations asynchronously on a background thread. This allows end users to access other UI controls without distraction. You can apply this only for pivot data sources.
The UWP Pivot Grid can load a large set of records on demand in little time. You can apply this only for pivot data sources.
The UWP Pivot Grid control simulates the pivot table feature of Excel. The data source for the control should be either OLAP or pivot data sources:
All features will work on touch devices with ease. Features such as drill up or down, filtering and sorting can be done on the fly.
Responsive support allows the control layout to be viewed on mobile devices.
End users can easily slice and dice the OLAP cube elements of their choice to visualize performance, trends, outliers, and more.
The slice and dice feature creates a new view for the end user by selecting limited dimensions and measures from the OLAP cube and filtering them.
KPIs are a collection of calculations associated with a measure group that evaluates business success.
Extensive support has been provided to load and render large amounts of data through paging or virtual scrolling without any performance constraints.
Named sets simplify MDX queries and provide useful aliases for complex, commonly used set expressions.
You can create and display dimensions and measures on your own.
Provides basic information about each member in each tuple, including member name, parent level, and number of children. These member properties are available for all members at any given level.
The grouping bar is automatically populated with fields from the bound data source. It allows end users to drag fields, filter and sort them, and alter pivot views at runtime.
There is built-in support to drill down (expand) and drill up (collapse) to visualize the grid information in both abstract and detailed views.
Edit values at runtime, thereby updating the total cell simultaneously. You can apply this only for pivot data sources.
Update values in real time by pushing the live data and refreshing the control whenever it’s required. You can apply this only for pivot data sources.
Built-in header and Excel-like filter UIs with advanced filtering options to easily filter and view data. It is also possible to filter programmatically.
Display only selective values for a field through UI or code-behind.
Filter column and row headers based on either label text or the grand total value. You can apply this only for pivot data sources.
Sorting support to order rows and columns, either based on labels or values.
Order the column and row header text either in ascending or descending order.
Order the column and row header text based on the custom comparer defined by the user. You can apply this only for pivot data sources.
Provides extensive support for you to define your own custom summaries, along with 10 built-in summary types. You can apply this only for pivot data sources.
Allows inserting new calculations at runtime, along with 16 built-in calculation types. You can apply this only for pivot data sources.
The calculated field, otherwise known as unbound field generates unique field with our own calculated value by executing a simple user-defined formula. You can apply this only for pivot data sources.
Expression field generates data by executing the user-defined expression. The generated data are specific to few field(s) from the underlying data source. You can apply this only for pivot data sources.
The drill-through feature easily obtains a list of raw items for a particular value cell or summary cell. You can apply this only for pivot data sources.
Format the column headers, row headers, summary cells, and value cells.
Allows users to define conditions that, when met, format values and summary cells font and color settings.
Number formatting and date formatting help to transform the appearance of the actual cell value.
Users can visualize the control either as a flat grid or a pivot table similar to Excel. Users can also hide summaries or position it at the top.
This looks like the pivot table in earlier Excel versions, allowing the end user to pivot rows, columns, and calculations.
Summary layout easily switches the summary position either to the top or bottom beside each field in the control.
Excel-like layout simulates the pivot table look and feel from Excel with child members positioned below the parent member and some indent space. You can apply this only for OLAP data sources.
No summaries layout hides the subtotal and grand total and shows only header and value cells. You can apply this only for OLAP data sources.
Subtotals and grand totals are calculated automatically by the pivot engine inside the source and displayed in the UWP pivot grid. This helps users make decisions based on the totals. Users of pivot data sources alone can show or hide subtotals and grand totals for rows and columns.
Retrieve information about a particular cell on hyperlinked cell click. Perform custom operations programmatically as well.
It provides basic information about a cell while the mouse pointer hovers over it.
You can easily resize each column’s width through a simple drag operation at runtime.
There is built-in support for freezing row and column headers for better views of values in a pivot grid.
There is extensive support to select a range of value cells.
Settings in the UWP Pivot Grid control can be serialized to an XML format and loaded back through the built-in deserialization options. You can apply this only for pivot data sources.
The UWP pivot grid has a rich set of options available for exporting data to Excel, Word, PDF, and CSV. Several options are also provided to customize the exporting operations.
Ships with built-in themes like Blend, Office 2010, Office 2016, Office 365, Visual Studio 2013, Visual Studio 2015, Metro, Lime and Saffron.
Customize the appearance of the control to any extent programmatically.
For a great developer experience, flexible built-in APIs are available to define and customize the UWP pivot grid control. Developers can optimize the data bound to the control and customize the user interface (UI) completely using code with ease.
Allows users from different locales to use the control by applying date format, currency format, and number format to suit local preferences.
The text direction and layout of the control can be displayed in the right-to-left (RTL) direction.
Allows users to customize the text in the user interface based on the local culture.