8 New ASP.NET PivotGrid Features Not to Miss

Although Telerik’s ASP.NET PivotGrid control is in still beta, it is getting full of useful features. Some of them are requested by our clients who have started using the control since its CTP release, and the other have to be implemented because the pivot table’s concept requires them. Below I am listing the most recently added functionalities:

1. PivotGrid ConfigurationPanel
2. Filtering
3. PivotGrid Layouts
4. Totals Placement Modes
5. Aggregates Position
6. Tooltips
7. Drag to Group
8. Range Grouping (Group Date, Time and Numeric Values)

PivotGrid ConfigurationPanel

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. 

Filtering

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:

Filtering Options for Your Telerik ASP.NET AJAX PivotGrid

Filtering demo page

Filtering online documentation

PivotGrid Layouts

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.

Totals Placement Modes

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.

 

Aggregates Position

Like in Excel’s PivotTable, RadPivotGrid has the ability to show the aggregates position under column or row groups. The position is controlled by two properties: 

• AggregatesPosition - Sets whether the multiple aggregates will be positioned under row’s or columns’s groups
• AggregatesLevel – Sets the rendering level of aggregates groups.

For example:

• AggregatesPosition=”Column”

• AggregatesPosition=”Rows”

• AggregatesPosition=”Rows”
• AggregatesLevel=”1”

Tooltips

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

Drag to Group

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:

Range Grouping (Group Date, Time and Numeric Values)

RadPivotGrid supports three types of grouping by ranges for its row and column fields: DateTime, numeric and custom.

• DateTime range grouping - combines ranges of date time groups into Year, Quarter, Month, Day spans
• Numeric range grouping - aggregates numeric groups into custom numeric ranges (for example 0-10, 10-20, 20-30 etc.)
• Custom range grouping - provides the flexibility for custom way of grouping 

Range Grouping online example 

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.