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