SAP Knowledge Base Article - Public

2921306 - Show totals option is displaying the sum of all the lines, not the sum of Top N in SAP Analytics Cloud (SAC)

Symptom

Show totals option is displaying the sum of all the lines, not the sum of Top N in SAP Analytics Cloud (SAC).

Environment

SAP Analytics Cloud 2021.14

Reproducing the Issue

  1. Create a table with multiple measures and dimensions.
  2. Enable Show Totals option.
  3. Select Top 3.
  4. Observe the Totals.
  5. Change the Top 3 to Top 5.
  6. Observe that the Totals number has not changed.

Cause

This is the behavior by design.

Resolution

  • Totals are calculated in the backend - table request these data from backend. The function is designed in a way that always returns the total disregarding TOP N requests. So even if only 3 values are returned the Total reflects the sum of all data.
  • As a workaround frontend formulas to add the visible numbers can be used.

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, rank, ranking, table, N, top, create, total, totals, cross, disable, enable, sort, sorting, order, Top N. , KBA , LOD-ANA-TAB , Table , Problem

Product

SAP Analytics Cloud 1.0