Bottom 10 in a bar chart excluding zeros

[RMQLIKUSER]

Hi,

I am trying to get bottom 10 stores on a bar chart based on the total sales but would like to exclude the store which shows 0 sales.

For example

Store	Sales
A	10
B	20
C	40
D	30
E	90
F	0
G	0
H	0
I	0
J	0

In this case if i try to show the bottom 5, i would get the results with F G H I J but instead i would like to see A B D C E. How can i achieve this?

Tried using data handling> uncheck zero values..but no results

[sunny_talwar]

May be use this expression

Sum({<Store = {"=Sum(Sales) > 0"}>}Sales)

[NZFei]

Sum({<Store={"=sum(Sales)>0 and rank(1/sum(Sales))<=5"}>}Sales)