- Connecting to SAP BW
- SAP BO Analysis - Export Options
- Sharing Workspaces
- SAP BO Analysis - Sheets
- SAP BO Analysis - Hierarchies
- SAP BO Analysis - Aggregations
- SAP BO Analysis - Calculations
- Conditional Formatting
- SAP BO Analysis - Sorting
- SAP BO Analysis - Using Filters
- Sub Analysis
- Chart Types & Styles
- SAP BO Analysis - Charts
- SAP BO Analysis - Crosstabs
- SAP BO Analysis - Analyses
- Create a Workspace
- SAP BO Analysis - User Interface
- SAP BO Analysis - Overview
- SAP BO Analysis - Home
SAP BO Analysis Useful Resources
Selected Reading
- Who is Who
- Computer Glossary
- HR Interview Questions
- Effective Resume Writing
- Questions and Answers
- UPSC IAS Exams Notes
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.
![Aggregation Type](/sap_bo_analysis_edition_for_olap/images/aggregation_type.jpg)
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.
![Position Totals](/sap_bo_analysis_edition_for_olap/images/position_totals.jpg)
You can also position the totals after members from the dropdown pst.
![Members Totals](/sap_bo_analysis_edition_for_olap/images/members_total.jpg)