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 2018.20.0

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

https://sapjira.wdf.sap.corp/browse/FPA29-6134

Keywords

Totals, Top N, not calculating, value wrong, dimension, measures , KBA , LOD-ANA-BI , SAP Analytics Cloud - Business Intelligence (BOC) , Problem

Product

SAP Analytics Cloud 1.0