PivotGridFieldCollection.Add(String, PivotArea) Method

Adds a new field with the specified field name and location to the end of the collection.

Namespace: DevExpress.Web.ASPxPivotGrid

Assembly: DevExpress.Web.ASPxPivotGrid.v18.2.dll

Declaration

C#

public PivotGridField Add(
    string fieldName,
    PivotArea area
)

VB.NET

Public Function Add(
    fieldName As String,
    area As PivotArea
) As PivotGridField

Parameters

Name	Type	Description
fieldName	String	A string that identifies the name of the database field that will be assigned to the new PivotGridField object.
area	PivotArea	A PivotArea value that identifies the area in which the new PivotGridField object will be positioned.

Returns

Type	Description
PivotGridField	The PivotGridField object that has been added to the collection.

Remarks

This method creates a new PivotGridField object, initializes it with the specified settings and appends it to the collection.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the Add(String, PivotArea) method.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

how-to-hide-particular-rows-and-columns-e2767/CS/ASPxPivotGrid_HidingColumnsAndRows/Data.cs#L22

public static void FillPivot(ASPxPivotGrid pivot) {
    pivot.Fields.Add(Employee, PivotArea.RowArea);
    pivot.Fields.Add(Widget, PivotArea.RowArea);

how-to-locate-field-value-cells-matching-a-particular-condition-e2770/CS/ASPxPivotGrid_FindCells/Data.cs#L22

public static void FillPivot(ASPxPivotGrid pivot) {
    pivot.Fields.Add(Employee, PivotArea.RowArea);
    pivot.Fields.Add(Widget, PivotArea.RowArea);

how-to-split-field-value-cells-e2762/CS/ASPxPivotGrid_SplittingCells/Data.cs#L22

public static void FillPivot(ASPxPivotGrid pivot) {
    pivot.Fields.Add(Employee, PivotArea.RowArea);
    pivot.Fields.Add(Widget, PivotArea.RowArea);

VB.NET

how-to-hide-particular-rows-and-columns-e2767/VB/ASPxPivotGrid_HidingColumnsAndRows/Data.vb#L26

Public Shared Sub FillPivot(ByVal pivot As ASPxPivotGrid)
    pivot.Fields.Add(Employee, PivotArea.RowArea)
    pivot.Fields.Add(Widget, PivotArea.RowArea)

how-to-locate-field-value-cells-matching-a-particular-condition-e2770/VB/ASPxPivotGrid_FindCells/Data.vb#L25

Public Shared Sub FillPivot(ByVal pivot As ASPxPivotGrid)
    pivot.Fields.Add(Employee, PivotArea.RowArea)
    pivot.Fields.Add(Widget, PivotArea.RowArea)

how-to-split-field-value-cells-e2762/VB/ASPxPivotGrid_SplittingCells/Data.vb#L25

Public Shared Sub FillPivot(ByVal pivot As ASPxPivotGrid)
    pivot.Fields.Add(Employee, PivotArea.RowArea)
    pivot.Fields.Add(Widget, PivotArea.RowArea)