To remove all the aggregate
functions and group by settings:
-
On the Column
Editor tab, select all the columns.
-
Right-click, and select Remove
Aggregations.
Tip
This menu option is available
only when all of the columns are selected and at least one aggregation
is defined.