'Declaration Public ReadOnly Property Fields As PivotFieldList
public PivotFieldList Fields {get;}
'Declaration Public ReadOnly Property Fields As PivotFieldList
public PivotFieldList Fields {get;}
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.
// 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();