Field Groups
Fields can be combined into groups (also called field groups). Visually field headers within a group are linked with each other. Fields within a group are treated as a whole and are always moved together and are displayed within the same area and in the same order. End-users cannot separate these fields by dragging one of them to a different area or hiding it to the customization form. A field can belong to a single group (if any) at a time.
Field groups are stored in the pivot grid’s Groups collection. To place a group in a specific area or in a new position within the current area, use either the group’s Area and AreaIndex properties or the Area and AreaIndex properties of the first field in the group. Modifying the Area and AreaIndex properties of the second and subsequent fields in the group is ignored.
Grouped fields can be collapsed and expanded by clicking the expand buttons. Collapsing/expanding a grouped field header collapses/expands the columns or rows that correspond to grouped child fields. The GroupExpanded property allows you to determine or modify the expansion status of an individual grouped field via code.
