I need Brand Name.

[#1]

max(aggr((count(Sentiment)/Count(TOTAL Sentiment))*100,Brand))

I am using the above expression and getting the maximum sentiment % of a Particular Brand but I want to find the name of the Brand which has maximum sentiment %age.

So ,Please Help me on this.

Thanks in Advance.

[#2]

The above  Solution is used to find the 2nd highest brand .

For Ist Highest brand Use:-

MaxString(If(AGGR(Rank(count(Sentiment)),Brand)=1,Brand))