SAP Knowledge Base Article - Public

2705419 - How to calculate total number of male and total number of female employee in advance reporting?

Symptom

  • Is it possible to calculate the total number of Male Employees are present in the organization?
  • How to calculate total number of female employees are present in the organization?
  • All Images are taken from Demo system.

Environment

 Advance Reporting (Realms)

Resolution

  • Create Aggregated Calculated Column in Advance Reporting (Realms).
  • Provide Aggregated Calculated Column name
  • Edit Column > Select the Column "Gender" from User Sys Info Table > Apply "Count" Aggregate Function > Apply Filter on Gender = M

Gender Aggregated Calculated Column.png

 

  • Create a Pivot Query > Take the Aggregated Calculated Column under "Measures" > Apply SUM Pivot function.

Gender Column - Pivot SUM.png

Keywords

Aggregated Calculated Column, Advance Reporting, Realms, SUM, Pivot Measures, COUNT, Total Number, Gender , KBA , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , How To

Product

SAP SuccessFactors HCM Core all versions