SAP Knowledge Base Article - Public

3041807 - How to Hide Duplicates in Story in Classic Design Experience (CDE)


How to Hide Duplicates in Story

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.


  • SAP SuccessFactors HXM Suite
  • People Analytics
  • Story Reports


We call a row a duplicate only if all the values are same in more than one row.

Getting duplicate rows in a list report is very common. This could be expected if we query a database table that holds the same values for a user up to certain fields (say Set A) and different values in remaining fields (say Set B). Now, if we just add fields from set A in a report, it will output the same values for a user in multiple rows.

In Stories, we can easily hide the duplicate rows by using Aggregated List Type


See Also

See more details on Our portal: People Analytics – What it offers distinctively?


SAC, People, Analytics, Story, Reports, Hide, Duplicates, Enable, Distinct , KBA , LOD-SF-ANA-SAC-SDS , Story Designer - Story & Formatting , How To


SAP SuccessFactors HXM Suite all versions