C1.PivotEngine.C1PivotEngine.Fields

Fields Property

Fields

Gets the list of PivotField objects exposed by the data source.

Declaration

public PivotFieldList Fields { get; }

Public ReadOnly Property Fields As PivotFieldList

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.

Examples

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();