Fields Property (C1PivotEngine)

In This Topic

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

Syntax

Visual Basic
C#

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

Reference

C1PivotEngine Class
C1PivotEngine Members