Displaying companies with Variants greater than A in Bar chart

[#1]

Hi Everyone,

There are 2 dimensions company code,Variant code and 1 measure- score.I want to display the companies  whose variants greater than Company A  in a Bar chart(Grouped).Please find the attached Raw Excel file and the the output should be like the attached QVW.

Kindly help me in arriving at this logic.

Thanks & regards,

Hari

[its_anandrjs]

As i understand for your query take a Bar chart and

Dimension :- Variant Code , Company Code

and

Expression :- =Sum(Score)

[jerem1234 · Accepted solution]

Please find attached. I used this formula:

if(sum(Score) >= sum({<[Company Code] = {'A'}>}total <[Variant Code]> Score) and firstsortedvalue(total <[Variant Code]>[Company Code], -aggr(sum(Score), [Variant Code], [Company Code])) <>'A', sum(Score))

Hope this helps!