Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!!
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!!
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!!