pivot table

A table with fixed roles and types for its columns, suitable for processing and aggregating multi-dimensional data. A pivot table has two types of columns (dimensions and measures) and one type of row (fact row). Data is sorted by the dimensions, and the measures are aggregated.