Set analysis for choosing a rank

[adnan_rafiq]

Hi QV Champions.

I am stuck in a situation where I need to make charts based on a particular ranking object. The Chart I have made is as follows

Here I have products and Net Sales, Gross margin and Pocket margin. I have rank expression is : Rank(Total sum(Gross Margin Actual),1).

I want to make 10 charts : the first for the product that is rank 1,another for product that is rank 2 and so on until 10.

All suggestions welcome, especially if we can use a set analysis based on rank.

Cheers

[devarasu07]

Hi,

You can write like this,

Rank 1:

=only(aggr(if(rank(sum(Gross Margin Actual)),4)=1, [Product Name]), [Product Name]))

Rank 2:

=only(aggr(if(rank(sum(Gross Margin Actual)),4)=2, [Product Name]), [Product Name]))

FYI,

Mock app,

Worst Selling 5 Products?

[adnan_rafiq]

Thanks for reply devarasu07

My idea is I should one chart which only has one product coke 375 ml, another chart only having MLKC6 DBL

[devarasu07]

Hi,

Yes it should work. give a try and let us know if still have issue send us the mock app with source and expected output in excel will try to help you. tks

Regards,

Deva

[adnan_rafiq]

Will this method also produce charts like this?