Fields Property (C1PivotEngine)
Gets the list of
PivotField objects exposed by the data source.
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();
