Skip to main content

ASPxPivotGrid.Groups Property

Gets the collection of field groups.

Namespace: DevExpress.Web.ASPxPivotGrid

Assembly: DevExpress.Web.ASPxPivotGrid.v24.1.dll

NuGet Package: DevExpress.Web


public PivotGridWebGroupCollection Groups { get; }

Property Value

Type Description

A PivotGridWebGroupCollection object which represents a collection of field groups.


You can arrange individual fields into a group (the PivotGridWebGroup object). Use a field’s unique identifier to determine the field in a group. For this, assign a unique value to the PivotGridField.ID property. Fields in a group are treated as a whole, and are always displayed in the same area. You cannot separate these fields, for example, drag a field to a different area or hide it in the customization form. If you drag a field from a group to another position, the entire group is moved.

Remove the group to ungroup the fields. Note that fields are not disposed of in this case.


Follow the steps below to create a new group at design time:

  • Invoke the ASPxPivotGrid Designer.
  • In the Fields and Groups page expand the ColumnArea and select the Year, Quarter and Month fields. Hold down SHIFT or CTRL while you click field names to select multiple fields.


  • Then click the Move to a new group button, that creates a new Year-Quarter-Month group and moves the selected fields into it.


The image below show the result.


The following code demonstrates how to combine fields into a group at runtime.

In this example, three fields (Year, Quarter and Month, respectively) are combined into a new group. This ensures that the Year field will be followed by Quarter which in its turn is followed by Month. If the Year field is being dragged to another area other fields will be dragged as well.

using System;
using DevExpress.Web.ASPxPivotGrid;

namespace ASPxPivotGridFieldGroups
    public partial class WebForm1 : System.Web.UI.Page {
        protected void Page_Load(object sender, EventArgs e)
            // Creates a PivotGridWebGroup instance.
            PivotGridWebGroup groupOrderDate = new PivotGridWebGroup();

            // Adds fields to the created group.

            // Adds the created group to the collection of the ASPxPivotGrid groups.
See Also