A pivot table provides a useful mechanism for aggregating and summarizing data. In effect, you are taking the flat rows of data and grouping them into a multi-dimensional representation of the data, enabling easier data analysis. When formatting a Pivot Table, only three fields are used (row, column, and data). Use the Move Up and Move Down feature to position the fields to easily select three fields. See also: