Creates a new page of popular aggregations (Sum, Minimum, Maximum, Average, Median, StdDev, NumericRange, First, Last) of rows, columns or the current page.  

Syntax:

AddAggregates, axis

Parameters:

Examples:

AddAggregates,Page

You get calculations that summarize the data on the page. In your user interface, sometimes this is a nice overview to show users.  Or, you can use one of the newly created cells on the page as a value to be compared to in the Compare function with AbsolutePosition as one of its parameters.

AddAggregates,Row

You get new data columns: Sum, Minimum, Maximum, Average, Median, StdDev, NumericRange, First, and Last. Often one of these cells can be a useful value for use with the Compare function, particularly with RelativePosition as one of its parameters.

AddAggregates,Column

Column headings are first converted to become the rows. Then they are treated just like rows: You get new data columns: Sum, Minimum, Maximum, Average, Median, StdDev, NumericRange, First, and Last.

Comments:

This function is useful when you want summary information or if you preparing to perform a Comparison operation. 

Author Mode menu:

Distribution -> Create a Summary Page