Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a requirement where I need to display bottom 10 suppliers by the certain calculated measure. Added condition is that, those bottom 10 values should be above 0 values.
I have tried putting an IF condition in the measure, and dimension is bottom ordered and a limitation of 10. However this is not working.
May be this:
Sum({<Suppliers = {"=Sum(Sales) > 0"}>}Sales)
and then may be use the dimension limits tab to show the bottom 10 suppliers