Pivot Fields are essential to make data aggregation and summarization possible.
There are 2 main types of fields, and all pivot fields fall into 1 of the 2 categories.
Contains fields used as "measures", typically numeric values that are summarized by the engine.
Contain fields used as "dimensions", typically strings or dates that are used to break up data into groups.
These field categories are more or less defined by the data type of the value associated with the field. It is important to keep this in mind when manipulating field lists for a desired summary.
The PivotEngine has several field lists. Some are Dimension Fields and some are Measure fields.
- Value Fields
- Column Fields
- Row Fields
- Filter Fields
To create views, you need to add fields to these lists. The next topics will demonstrate how to do this.