Symptom
What are Aggregated calculated columns?
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 HXM Suite
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:
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
- Calculated columns cannot be added as filter in the aggregated 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 HCM Suite all versions