Use the Auto-Aggregate Functions

The auto-aggregate feature is a productivity feature that enables you to specify a set of aggregations to apply as default aggregations to numeric columns for a specific table. A typical use is to automatically aggregate some of the columns in a fact table.
To use the auto-aggregate feature:
  1. Select a table on the Design tab.
  2. On the Inputs tab, select Enable for Auto-aggregate.
  3. Click the ellipsis button next to Aggregations to open the Choose Aggregations window.
  4. Select the check boxes for the aggregate functions that you want to apply, and then click Apply.
Whenever you add a column to the data query, the selected aggregate functions are automatically applied.