Set Analysis two conditions (rank)

[ssmhg2712]

Dear all,

i need your support for a chart with two set analysis conditions.

It´s a long list of articles with price. I want to show only the top10 articles without articles of type "Mono*"

Each of the condition is working and is showing 10 results.

But if i combine the two conditions i only get 6 results, as there are 4 articles in the TOP10 with articletype = "MONO".

Sum({<[articletype] -= {"MONO*"}, %article = {"=Rank(Sum(price*qty))<=10"}>} (price*qty))

Thank you for any help!

Kind regards, Sven

[MayilVahanan]

Hi @ssmhg2712 

Try like this

Sum({<[articletype] -= {"MONO*"}, %article = {"=Rank(Sum({<[articletype] -= {'MONO*'}>}price*qty))<=10"}>} (price*qty))

[ssmhg2712 · Accepted solution]

Hi,

thank you very much for your answer!

Your expression still showed only 6 results, but according to your proposal i found the correct one:

Sum({< %article = {'=Rank(Sum({<[articletype] -= {"MONO*"}>}price*qty))<=10'}>} price*qty))

Thank you very much for you help!

Kind regards,

Sven