The PivotGrid Configuration panel is similar to Excel PivotTable Field List and enables fields sorting, reordering and hiding operations. You could configure the Position, LayoutType, Showing ContextMenu via the ConfigurationPanelSettings class which contains all setting of the PivotGrid Configuration panel.
One of the most important features implemented into the latest version of the PivotGrid control is the option to filter the data shown in the control. The filtering is controlled by the EnableFiltering property and when it is set to "true" each filed render a small icon which open a filter window:
Into the Filter Window you could choose to include or exclude some of the unique group values by checking some of the checkboxes from the report filter. Also you can choose to filter by labels or values. The Label filters control which groups for a given field will remain in the pivot data view after grouping has been performed. The Value filters allow filtering operations to be performed on the aggregate results. More information about PivotGrid filtering you could find here:
The first CTP version of RadPivotGrid control had only one layout - Tabular. It shows the data in a traditional table format:
Into the Beta we added another two layouts which mimic the Excel PivotTable layouts - Outline and Compact. The Outline layout shows the data in a classic PivotTable style:
The Compact layout is used to keep related data from spreading horizontally off of the screen and helps minimizing the scrolling:
On the following link you could see an online example of three layouts.
Into the beta version of the RadPivotGrid there is a possibility for hiding all subtotals or totals records of the row and column groups or to change their places. This functionality is controlled by four properties from the RadPivotGrid.TotalsSettings class. The possible choices are: First, Last, None.
In Totals Settings documentation article you could find all cases, with visual representation of how the RadGrid will be rendered when these properties are combined with the different layouts of the PivotGrid.
The ToolTips feature of RadPivotGrid enables tooltips containing rich data to be shown for different cells of the control.
You can enable the tooltips through the EnableToolTips property of RadPivotGrid. When this property is set to true and the user hover a cell the summarized information is shown into dynamic created tooltip. More information and a live example you could find here:
PivotGrid tooltips documentation article
PivotGrid tooltips online example
The drag and drop functionality of RadPivotGrid fields allows the end user to display different results depending on their goals. Thus the users can modify the structure of the PivotGrid control and show different reports run time. The drag to group functionality is controlled by EnableFieldsDragDrop which belongs to the RadPivotGrid.ClientSettings class:
Above are the most “fresh” features of the RadPivotGrid control, however we will not stop here, more and more features will be introduced in the next versions of the control. In the meantime we will appreciate it if you give us any feedback on the already implemented features.
Radoslav Kirilov is a software developer at one of Telerik’s ASP.NET AJAX teams. Ever since he joined the company in 2009, he has been working on the data-bound and date-picker controls. His interests are primarily concentrated on ASP.NET, AJAX, MVC, SQL and best practices.
Subscribe to be the first to get our expert-written articles and tutorials for developers!