3735521 - Total for Measure configured with Max Aggregation Type in Cross-Table widget in does not show total for the measure only repeats the Max value in Successfactors People Embedded Analytics

• In the particular Table Widget the option "Show Totals" is enabled with the following 1-1 aggregated column present:
  
  • For “Amount (Rate)”, the aggregation type is NONE (which behaves the same as SUM).
  • For “Amount (Travel)”, the aggregation type is MAX.
• The Totals is correctly shown for the aggregation type none column.
• The MAX is not correctly shown as only the 1st row is shown as total.
  

• SAP SuccessFactors Platform
• Story Reports

1. Open Report Center and run a Story report that contains a table (cross-tab) with Show Totals enabled.
2. Include at least one measure aggregated with NONE/SUM and one measure aggregated with MAX.
3. Observe that row-level values display as expected.
4. Observe that the totals row for the measure aggregated with MAX shows the maximum single value rather than a summed total.

This behaviour is working as designed and is expected based on the current aggregation setting.

Since the measure is configured with MAX aggregation, the table displays the maximum value. To display the total for “Amount (Travel)”, the aggregation needs to be changed to SUM.

refer to: Create Aggregations in Tables

story reports, cross-tab, table totals, show totals, max aggregation, maximum, sum, none aggregation, totals row, measure aggregation, sac embedded, people analytics, incorrect totals, table widget, aggregation behavior , KBA , LOD-ANA-OEM , Embedded usage of SAP Analytics Cloud , Problem