Aggregation functions group together values from multiple fields to form a single compound value.

WebDataRocks Pivot Table offers 17 aggregation functions which you can apply to the measures in your report:

Name Value Description
Sum "sum" Adds all values in the row/column
Count "count" Counts the number of the rows/columns that contain values
Distinct Count "distinctcount" Counts the number of the rows/columns that contain unique values
Average "average" Returns the average (arithmetic mean) of the values in the row/column
Median "median" Returns the median of the values in the row/column
Product "product" Multiplies the values in the row/column
Min "min" Returns the smallest number in the row/column
Max "max" Returns the largest value in the row/column
% of Grand Total "percent" Calculates the values distribution across grand totals in the report
% of Column "percentofcolumn" Calculates the percent distribution across the columns
% of Row "percentofrow" Calculates the percent distribution across the rows
Index "index" Calculates the aggregated weighted average to reveal the impact of each value within the context of a dataset
Difference "difference" Calculates the difference between two values in the row/column
% Difference "%difference" Calculates the difference between two values in the row/column expressed in percentages
Population Standard Deviation "stdevp" Calculates population standard deviation of the values in the row/column
Sample Standard Deviation "stdevs" Calculates sample standard deviation of the values in the row/column
Running Totals "runningtotals" Calculates a running total (cumulative sum)

Next step

Learn how to add calculated values to enhance your crosstab experience. They are particularly useful if you need to apply several aggregations to the same measure.