Smallest Dimension limits

[jchoucq]

HI everybody,

for example, i want to show the 5 smallest sales in a bar chart and when i use Smallest Dimensions Limits, the bar chart gives no data to display because many salesman have no sales !

Is it possible, in a bar char to have the 5 smallest values, which are different from zero.

Regards,

Johann

[Gysbert_Wassenaar · Accepted solution]

It works with as calculated dimension if(aggr(sum(MT_FACT),CODE_CLT)>0, CODE_CLT) and Suppress When Value Is Null checked. See attached example.

[jchoucq]

Thanks a lot Gysbert.

For sure, how works Smallest Dimension limits is strange