Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Thanks a lot Gysbert.
For sure, how works Smallest Dimension limits is strange