SAP Knowledge Base Article - Public

2652161 - How to add a column for totals and subtotals in Online Report Designer?

Symptom

  • Unable to find the function to add up the subtotals and the grand total of the rows or columns(division/department etc.)
  • Is it possible to have other calculations over the results of the measures e.g. a pivot table has a count of employees by department and you want also to have an average of this result

Environment

SuccessFactors Workforce Analytics (ANA) - All versions

Reproducing the Issue

  1. Navigate to Analytics.
  2. Go to Report Designer.
  3. Add a Pivot table component.
  4. Add a Measure and try to do a totals and subtotals of rows/columns.

Cause

You can include the row/column count by adding a function within the pivot designer. However, other calculations over this result (e.g. average) are not available

Resolution

  1. Edit the query and enter the Pivot query Designer
  2. In the row element, edit and define the qualifier as "Selected element and all descendants"
  3. In the column element, edit and define the qualifier as the same.

 The difference in the three is:

  • Selected Element only will give just the Subtotal of all descendants
  • Selected Element and all descendants will give the Subtotal along with the breakdown below.
  • All descendants only would just give the breakdown of the descendant values.

Keywords

Pivot table, Online Report Designer, Totals, Subtotal, Report Canvas calculation , KBA , csg_q , LOD-SF-ANA-ORD , Online Report Designer , How To

Product

SAP SuccessFactors HCM Core all versions ; SAP SuccessFactors Workforce Analytics all versions