DataEngine for .NET Standard | ComponentOne
C1.PivotEngine Assembly / C1.PivotEngine Namespace / C1PivotEngine Class / Fields Property
Example

In This Topic
    Fields Property (C1PivotEngine)
    In This Topic
    Gets the list of PivotField objects exposed by the data source.
    Syntax
    'Declaration
     
    Public ReadOnly Property Fields As PivotFieldList
    public PivotFieldList Fields {get;}
    Remarks

    This list is created automatically whenever the DataSource property is set.

    PivotEngine views are defined by copying fields from this list to the lists that define the view: ValueFields, RowFields, ColumnFields, and FilterFields.

    Example
    The code below assigns a data source to the PivotEngine and then defines a view by adding fields to each of the RowFields, ColumnFields, and ValueFields lists.
    // set data source (populates Fields list)
    fp.DataSource = GetDataTable();
                
    // prevent updates while building PivotEngine view
    fp.BeginUpdate();
                
    // show countries in rows
    fp.RowFields.Add("Country");
                
    // show categories and products in columns
    fp.ColumnFields.Add("Category");
    fp.ColumnFields.Add("Product");
                
    // show total sales in cells
    fp.ValueFields.Add("Sales");
                
    // done defining the view
    fp.EndUpdate();
    See Also