Format in Straight Table

[Anonymous]

Hi All,

In a straight table i need to bold values on first occurrence of max value,
condition is all the columns has to compare trigger value(100) and it is should bold the first occurrence of max value
Example

First row : 100 > 94 and 100 > 120 and 100 > 97 (120 should be bold)

Second Row : 100 > 120 and 100 > 110 and 100 > 105 (120 should be bold)

Third Row : 100 > 90  and 100 > 97 and 100 > 110 (110 should be bold)

O/P should be

Thanks in advance

[stabben23]

if(sum( aggr(sum(expression),Emp, Trigger))= max(TOTAL aggr(sum(expression),Emp, Trigger)),'<B>')

use this in textformat in your Expression.

click on the + sign at Your expression to find it.

[jonathandienst · Accepted solution]

You can use the text format property of the expression with expressions like:

     =If(A > B And A > C, '<B>')     (for expression A)

     =If(B > A And B > C, '<B>')     (for expression B)

     =If(C > A And C > B, '<B>')     (for expression C)

[tresesco]

May be like in attached sample.

[Anonymous]

Hi Jonathan ,

Thanks for the reply, worked perfectly as expected ,

If(A > B And A > C, '<B>')     (for expression A)

modified your expression

f(A > B And A > C and A > TrigerValue, '<B>')   for expression A and remaining expressions

Thanks to all