C1.PivotEngine.C1PivotEngine.Fields

Fields Property

Fields

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

Declaration

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.

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