what is my bottom 5 stores have poor inventory among the top 20 stores in sales?
I am having a business scenario need show some values from a returned set in straight table. A typical question is, what is my bottom 5 stores have poor inventory among my top 20 stores in sales? I only need show these 5 stores names with two columns, one is inventory level, one is sales $ amt. What is the best way to solve it in Qlik Sense.
I attached a sample excel, the expecting result should be as follows, Thanks.