Overview
- Converts row-level values into column headers
- Requires a group-by field, a pivot field (whose values become columns), and a value field
- Applies an aggregation function when multiple values exist for the same group/pivot combination
Configuration
1
Select the group-by field(s) — these define each output row.
2
Select the pivot field — unique values in this field become new columns.
3
Select the value field — the data that populates the new columns.
4
Choose an aggregation function (SUM, COUNT, AVG, MIN, MAX) for cases where multiple values exist.
Example
Input with fields:Region, Quarter, Revenue.
Pivot on Quarter, group by Region, aggregate Revenue with SUM.
Result: one row per Region with columns Q1, Q2, Q3, Q4 containing revenue totals.