Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'd like to set a particular background color in a straight table when a value in a specific columns is equivalent to the max of the values of the same column.
The value of the colums is calculate as Sum(Price) and the columns name is "Prices"
I set the background color function as follow:
IF([Prices]=Max(TOTAL Sum(Price)),Green())
but it doesn't work; the max function is wrong 'cause if i change the function as follow:
IF([Prices]>10,Green())
it works properly.
Should someone help me with the max function, pls?
Thank you.
N.
The easiest way of doing it is by using Rank.
=if(Rank( total Prices)=1,Green())
see attached.
Kindly provide some sample data...
maybe
if(sum(Price)=max(total aggr(sum(Price), Dim1)), green(), red())
replace Dim1 with your dim or dims
The easiest way of doing it is by using Rank.
=if(Rank( total Prices)=1,Green())
see attached.
Thank you very much!!
Thanks also to the others for the answers.
Have a nice day.
N.