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.