Home / SAP BO

Creating Totals and Subtotals - SAP BO

Rating: 5.0Blog-star
Views: 8937
by Raunaak
Last modified: April 5th 2021

After having FORMATTED and SORTED the data in our cross tab, let us now look at the options to include subtotals and grand totals as a part of the data set. Our current workspace from the previous section shows the characteristics of Country and Region in the Rows, and the key figures Net Value, Product Cost, and Transport Cost in the columns. In addition, we also have subtotals per Country in the Rows and we also have grand totals, which are shown at the top of the rows (see Figure 4.49).

How to Create Totals and Subtotals - SAP BO

Analysis Workspace
Figure 4.49 Analysis Workspace

  1. Select Germany as part of the characteristic Country in the cross tab.
  2. Navigate to the tab Display.
  3. Open the menu Totals & Parents (see Figure 4.50).

[Related Article: Business Objects Reporting Tutorial]

Totals & Parents

Figure 4.50 Totals & Parents

Right now, the cross tab is showing subtotals and grand totals, which is the reason for the checkmarks in the menu.
You can use the menu option Total Settings to decide if the subtotals and grand totals are shown After or Before the actual members and if you would like to see the totals in the rows and columns.

In our example, we are looking at the totals for the rows only, even though the menu indicates totals for the rows and columns, but we are not using any character in the columns and therefore there are no subtotals in the columns.
 4. Navigate to the menu Totals & Parents > Totals Settings and activate the option After
 5. Navigate to the menu Totals & Parents > Totals Settings and ensure the option In rows and columns is activated.
 6. Drag and drop characteristic Product Category to the Columns, so that is will be shown as below in the Key Figures (see Figure 4.51).

[Related Article: SAP BO Interview Questions for Experienced]

Analysis Workspace
Figure 4.51 Analysis Workspace

Now our cross tab contains characteristics in the Rows and in the Columns and therefore we can see the subtotals and grand totals not only for the Rows but also for the Columns.

Subtotals in the BEX QUERY

SAP BUSINESSOBJECTS ANALYSIS, EDITION FOR OLAP will leverage the configuration from the BEx query regarding the placement of subtotals or the option to suppress or show subtotals for a particular characteristic or hierarchy.

[Related Article: Business Objects Analysis]

In the next section, we will learn how to create filters in our workspace.

Explore SAP BO Sample Resumes! Download & Edit, Get Noticed by Top Employers!Download Now!

About Author

author
NameRaunaak
Author Bio

As a content writer and storyteller, Raunaak Mitra regards himself to be a prodigy in writing. He firmly believes that language is borderless, and anyone can write as long as they have a strong narrative capability and the ability to emote feelings into words. Authors like F. Scott Fitzgerald and R. K. Narayan have influenced him to keep the writing as simple as possible for anyone to understand. Other than being well-versed about technological trends like AI, Machine Learning, AR, VR, Gaming, Microprocessors, Cloud Computing, Industry 4.0, literally any technological advancement (old or new), he also shares a knack to curate fiction on sci-fi, satire, and thriller genres.