Total in straight table for the first N records

[Anonymous]

Hey guys!

I would like to receive your expertise on the following problem:

I am creating straight table to calculate sum of sales (with descending order) with limited quantity of records (defined in the Presentation tab), but it seems, that  total in expression takes all records, not those, which are presented in result.

Is there any possibility to make total value reflecting only with visible records?

Expected result of total => 4 566

Thanks in advance!

[sunny_talwar · Accepted solution]

Use this expression instead of using the settings on the presentation tab

=If(Rank(TOTAL Sum(Sales)) < 6, Sum(Sales))

and also make sure to select "sum of rows" under Total Mode on the expressions tab

[Anonymous]

Thanks, man!!!!