SAP Knowledge Base Article - Public

2501329 - How to display Sub-Total / Grand Total across columns / rows in ORD?

Symptom

How to display the sub-total across columns in Online Report Designer?

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

SAP SuccessFactors HCM Suite

Resolution

In order to display the sub-total, create a Pivot Query.

Below Pivot query displays the number of job requisitions per recruiter.

start_1.jpg

  1. Edit the query and switch to 'Design View'.

    Edit_qry_1.jpg

  2. Edit the desired column(s) / dimension(s).

    edit_columns.jpg

  3. Choose ‘Selected element and all descendants’ in the Pivot dimension editor.

    pivot_dimesnion.jpg


  4. Save the configuration by clicking OK and switch to Table view, to preview the results.

    Output.jpg

The same can be applied to find the total across rows as well.
More features of the Online Report Designer have been explained the following page in the Community portal:

See Also

Keywords

Sub-total, Online Report Designer , KBA , LOD-SF-ANA-ORD , Online Report Designer , How To

Product

SAP SuccessFactors HCM Suite all versions