Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have field ' Line',' Tank',' Code'
Used to make a Pivot Table.
Used Dimensions Line' and ' Tank'
Used Expressions Count(Code)
I want to add red with max 3 values on each line.
code used now but the value is incorrect : If(count(Code) = Max(total <Line> Aggr(count(Code), Line, Tank)), LightRed()
,)
I want to add red with max 3 values on each line.
@Sxbbb if I understood correctly, you can but below expression
=if( aggr(rank(count(Code) ,0,4), Line, Tank) <=3, LightRed())
I open ToTal and I want to add red with Max ToTal value
@Sxbbb expression which I shared is not working? What is expected output?