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.
- Edit the query and switch to 'Design View'.
- Edit the desired column(s) / dimension(s).
- Choose ‘Selected element and all descendants’ in the Pivot dimension editor.
- Save the configuration by clicking OK and switch to Table view, to preview the results.
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:
- Online Report Designer Feature Videos
- KBA 2291236 - Comprehensive Guide to Online Report Designer (ORD): Training, Documentation, Implementation and Support
See Also
- Online Report Designer Feature Videos
- KBA 2291236 - Comprehensive Guide to Online Report Designer (ORD): Training, Documentation, Implementation and Support
Keywords
Sub-total, Online Report Designer , KBA , LOD-SF-ANA-ORD , Online Report Designer , How To
SAP Knowledge Base Article - Public