This content has been marked as final. Show 1 reply
Yes tried this once.
Use three columns
2. Measure column
Third column should have the column formula as-
case when Rcount(Measure_column)=2 then 'Max'||MAX(Measure_column) end
Use the column formula in the second measure column itself as
cast(Measure_column as char)||case when Rcount(Measure_column)=2 then 'Max'||MAX(Measure_column) end
NOTE- 2 above refers the position where the message has to be displayed.
Award if this is helpful.