Set Analysis

[#1]

How can we arite a Set Analysis expression for displaying values corresponding to onlly top 20 rows of field. Expression should exclude all other values and show just top 20 rows values.

Please help.

[MK_QSL]

Use Dimension Limit

[JonnyPoole]

Here is the screenshot to assist

Dimension limits are available on charts and relate to the first expression (see below).

If you decide to  'show others' , make the number 21 (others counts as a display row...so top 20 + others = 21)

[JonnyPoole]

or if you need to do it on other expressions ( not the first)  then your set analysis will be something like this:

=sum( {$<Country = {"=rank(Total sum(Sales)) <= 20"}>} Sales )