Dimension Limit

[#1]

Hi,

I am trying to use dimension limits, but it is only working on the "top" 5 but not the "bottom" 5. What could be a reason for this, and how can it be fixed?

[nico_ilog]

How are you implementing the Limits?

Nico

[Chanty4u]

u can try below

Top 5 & Bottom 5 Values

Bottom customers:

FirstSortedValue(Customer, Aggr(Sum(Sales),Customer),1)

FirstSortedValue(Customer, Aggr(Sum(Sales),Customer),2)

...

FirstSortedValue(Customer, Aggr(Sum(Sales),Customer),5)

Topcustomers:

FirstSortedValue(Customer, -Aggr(Sum(Sales),Customer),1)

FirstSortedValue(Customer, -Aggr(Sum(Sales),Customer),2)

...

FirstSortedValue(Customer, -Aggr(Sum(Sales),Customer),5)

[rubenmarin · Accepted solution]

Hi Robyn, maybe there are lower values with both expressions=0 and 'Supress Zero values' is checked?

[#5]

Hi Nico,

[#6]

Thank you! That worked.

[#7]

Ruben,

Thank you so much.

Suppress Zero Values was checked.

I unchecked it and now it works!

[nico_ilog]

Hi Rob,

How can i be of assistance?