Pivot grid is a powerful pivot table implementation for visualizing relational data in a multidimensional UI. The pivot grid, as the name implies, pivots the data to organize it in a cross-tabulated form. The pivot grid is just like our grid, but works with relational data. Our powerful in-memory pivoting engine can transform hundreds of thousands of relational table rows into comprehensible pivot information within seconds. Along with pivoting, summarizing and grouping data are also supported.
Pivot grid simulates the pivot table feature of Excel. It accepts any kind of data collection. The data source for the pivot table should be either an IEnumerable list or a data table.
The pivot grid control’s grouping bar is automatically populated with fields from the bound data source and enables end users to drag fields between different areas, such as columns, rows, values, and filters, and create pivot views as they wish.
Pivot grid supports filtering the data as it limits the amount of information displayed for better readability. You can apply ‘n’ number of filtering conditions to the grid at a time. Data will be filtered based on the filter expression specified.
You can simply toggle the sort order by clicking on the field headers in the row and column header area. You can also configure the control to restrict run time sorting to just dimension columns and/or the total columns.
This feature allows users to sort column values in ascending or descending order. We can enable or disable sorting for all columns, only total columns, or only grand total columns.
The grouping bar context menu allows you to launch a pivot grid field list, move the field back or front, and reload the grid with updated data in the bound list.
Expand/collapse operations can be done at both the UI and programmatic level. The context menu will be shown while right-clicking on the expander cell.
Pivot grid Silverlight provides built-in support for freezing column and row headers.
The pivot grid for Silverlight allows the hyperlinking of cells to retrieve a detailed descriptions about a particular cell. You can enable a cell as a hyperlink and can perform some custom operations on a cell click. While doing so, you can get the complete information of the cell, like its type or range.
Tooltips can be set to individual cells. The tooltip information has the cell value and its respective row and column data and it is set in the style’s tag property. Tooltips can be used to show the data of any cell so that users can get the cell’s full information, for example, the row and column on which it depends.
Editing and updating the value cells and total cells is possible now in the pivot grid control. While handling the editing and updating operations, pivot grid will calculate the values automatically and its total values will be reflected. Editing and updating features are useful when users would like to edit the values at run time and save their changes to the underlying data source, thereby reflecting its update in the total cells.
Custom calculations can be applied to the value fields through the following built-in calculation functions: percentage of grand total cell, percentage of column total cell, percentage of row total cell, percentage of parent total cell, percentage of parent column total cell, percentage of parent row total cell, index, formula. The user can easily analyze the specific value field based on the different value cells through the custom calculations.
The delete operation can be easily performed using the context menu, but when adding an item, there should be a separate window, which should hold the fields present in the item source. In order to achieve this, a window called pivot grid field list is available in the pivot grid control. This feature will be useful for applications that need to configure pivot grid to add/remove items to/from pivot grid at run time.
Pivot grid for Silverlight supports Excel-like cell selection where you can select grid value cells as like in Microsoft Excel.
Theming is the process of applying particular settings to the visual elements of a product. This feature provides the following theming options: Office 2010 blue, Office 2010 black, Office 2010 silver, transparent, Office 2007 blue, Office 2007 black, Office 2007 silver, blend, metro, Office 2003, default. This feature enables users to develop a single application and apply different looks as necessary.
Pivot grid allows the user to change the appearance of elements, such as column, row, summary, and value cells, that are present in the pivot grid by defining templates for each cell. The customized template can be defined for the following properties of pivot grid: ColumnHeaderCellStyle, RowHeaderCellStyle, SummaryHeaderStyle, SummaryCellStyle, ValueCellStyle.
Conditional formatting is the process of applying custom styles to any object based on certain conditions. Conditional formatting for pivot grid allows you to format the grid cells based on conditions.
The pivot grid control provides support for loading data in a unique UI thread. That is, the pivot grid control can perform long running operations asynchronously on a background thread so that users can access other UI controls while the grid is loading.
This feature provides support for users to load the pivot grid control with features such as sorting, filtering, editing, updating, tooltips, and grouping bar drag-and-drop operations in a child window.
Localization is the process of translating a globalized application into different languages or adapting a product to a specific country or region. This feature enables the users to view the pivot grid into their regional languages.
You can export a pivot grid’s content to Excel, Word, and PDF files with all formatting intact.
Pivot grid now provides support to export to Comma Separated Values format. Also, support to export more than one pivot grid control in a single instance to CSV is available now.