ReducedPivot

An intermediate class used in Pivot reducing operations.

Serves as a transitional step between performing a reduction on pivot groups and specifying how the resulting reduced rows should be represented in a resulting DataRow.

Available transformation methods:

• values — creates a new row containing the values from the reduced rows in the selected columns and produces a DataRow of these values;

• with — computes a new value for each reduced row using a RowExpression, and produces a DataRow containing these computed values.

Each method returns a new DataRow with pivot keys as top-level columns (or as column groups) and values composed of the reduced results from each group.

Check out Pivot grammar.

For more information, refer to: See "Pivot Reducing" on the documentation website.