Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Sheetal
Contributor II
Contributor II

Displaying bottom 10 non-zero values

I have a bar chart with product as the dimension and sum(sales) as the measure. I am trying to display the bottom 10 products, but only want to display those bottom 10 products which have sum(Sales) > 0. How can I go about achieving this?Thanks for your time.

Labels (1)
1 Reply
Lisa_P
Employee
Employee

Change your sales measure to exclude zero sales.
sum({<sales={">0"}>}sales)