SAP Knowledge Base Article - Public

2847192 - Aggregated Calculated Columns - Advanced Reporting in Canvas reports

Symptom

What are Aggregated calculated columns?

Environment

  • SAP SuccessFactors HCM Suite
    • Online Report Designer / Report - Canvas: Advanced reporting

Resolution

Aggregated calculated columns is a feature unique to Advanced Reporting data source in Canvas Reporting

Using this feature, you could apply aggregations like Max, Min, Count, Distinct count, etc. to just one column in the report.

You could also add filters and define custom date options for these calculated columns

The following guide explains the feature in detail:

Aggregated Calculated Column Wizard

Limitations to consider:

  • You cannot aggregate data from a column belonging to the Driving table. The column has to be from the related table
  • You cannot aggregate on a calculated column

Keywords

aggregated, calculated, column, max, min, distinct, count, first, last, concatenate, sum, advanced, report, canvas, pivot, one, single column , KBA , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , How To

Product

SAP SuccessFactors HXM Suite all versions