SAP Knowledge Base Article - Public

2716173 - Top N on table is not filtering the total in SAP Analytics Cloud

Symptom

The table is showing only "N" lines, but the "Show Total" that was activated for the dimension is still giving the total of all the existing lines.

Environment

SAP Analytics Cloud

Reproducing the Issue

  1.  Creating a table 
  2.  Selecting members by using "Top N"
  3.  "Show Total" provides the overall value of the existing members. 

Cause

This is currentlly a limitation.

Resolution

Workaround

  1. Highlight/Select the existing lines/members in the table.
  2. Click on the "Filter" icon on the right.

adsfads0.png

  1. Now the value of "Totals" shows correctly

See Also

  • KBA 3127086 - Totals in Charts are Different than totals in Tables in SAP Analytics Cloud (SAC) 

Keywords

Totals, Top N, not calculating, value wrong, dimension, measures , KBA , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , Problem

Product

SAP Analytics Cloud 1.0