Article: AN0001996Updated:
Pivot table groups the according to selected columns for row and column headlines.
After selecting a datasource and filter you have to select columns for grouping of rows and columns (Row captions and Column captions). At the end you select column containing values for the aggregation function.
The resulting table contains also summary data about processed values. The calculation depends on selected aggregation function.