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:
-
Select a table in the
design view and click
Properties to view
the table properties.
-
Use the
Auto-Aggregate menu
to set the value to Enabled.
-
Place your pointer in
the
Functions cell and then click the ellipsis
button to open the
Choose Aggregations window.
-
Select the check boxes
for the aggregate functions that you want to apply and then click
Apply.
Whenever you add a column
to the query, the selected aggregate functions are automatically applied.