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.
SAP Analytics Cloud 2018.20.0
Reproducing the Issue
- Creating a table
- Selecting members by using "Top N"
- "Show Total" provides the overall value of the existing members.
This is currentlly a limitation.
- Highlight/Select the existing lines/members in the table.
- Click on the "Filter" icon on the right.
- Now the value of "Totals" shows correctly
Totals, Top N, not calculating, value wrong, dimension, measures , KBA , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , Problem