SAP BO Analysis - Aggregations

You can perform totals in the crosstab rows and columns. When an aggregation is appped, default aggregation is Sum. You can also change default aggregation as per requirement. In a workspace, in Analysis Edition for OLAP, following aggregations are supported −

Default

Minimum

Maximum

Sum

Count

Average

Median

To display totals and subtotals, select a Crosstab in an Analysis and navigate to Display tab → Select Totals or you can also select a column in THE Crosstab on which you want to apply an aggregation.

You can also change the aggregation type by selecting Calculate Total As option.

To set up the position of Totals, select the Crosstab and cpck the Totals tab under Display. You have an option to select the position of totals in your analysis.

You can also position the totals after members from the dropdown pst.