Show Top 10 values in a Line Chart (Avoid 'Others'; No Dimension Limits: v10)

[dmohanty]

Hi All,

I have a scenario to restrict the values on X-Axis of a Line chart to Top 10 and ignore others. But I am getting one 11th record as 'Others' (summation of rest values). Also I can't use Dimension Limits to restrict as it's version 10.

For example, I have 20 Years as dimension and Total Sales as KPI.

So could any one help me out how to ignore the 'Others'?

Regards!!!

[dmohanty · Accepted solution]

Hi All,

I got the result by implementing the below Expression:

Sum({<Year = {"=Rank(sum(Sales))<=10"}>}Sales)

Also, in the Sort options, only enable: Y-value as Descending.

Also, if anyone has any other ways to implement, they are welcome to post.

Regards!!