3639084 - How To Keep Member Names or Repetitive Values in Cross-Tab Table (Grouped or Aggregated) Display for Story Reports

• In a Story Report (Cross-Tab), identical values in consecutive rows are grouped together, causing subsequent rows to display blank instead of repeating the value.
• No error messages or error codes are associated with this issue.
  
  
  

  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 Story Reporting
  • Story Designer - Story & Formatting

1. Create a Story Report using the Cross-Tab report type in SAP SuccessFactors Story Reporting.
2. Populate the report with data containing identical values in consecutive rows for a specific column.
3. Observe that the first occurrence of the value is displayed, while subsequent rows with the same value appear blank.

The Cross-Tab report type is designed to aggregate or group identical values in consecutive rows by default.

1. Open the Story Report containing the Cross-Tab.
2. Right-click on the column header where the values are grouped.
3. Select "Table Functions" from the context menu.
4. Navigate to "Show/Hide" and select "Member Name".
5. Enable the option "Repetitive Member Names".
6. Verify that all rows now display the repeated values instead of leaving them blank.
   
   
   
   Result after choosing the option:
   
   

• Refer to: Cross-tab: displays the data that is grouped or totaled in two directions.
• Refer to: About Table Menu Options on Story Pages.

cross-tab, story report, repetitive member names, sap successfactors, grouped values, ungroup values, show repeated values, table functions, sap analytics cloud, story designer, report formatting , KBA , LOD-SF-ANA-SAC-SDS , Story Designer - Story & Formatting , LOD-ANA-OEM , Embedded usage of SAP Analytics Cloud , Problem