highlight duplicate values in a table

[ValeriaBonini]

Hi, I have this table where I would like to make the background red if the Name is duplicated

I tried with if(count( Total <id_utente>{<id_utente=>} nome_utente) > 1 , '#f9ebe9') but it has not worked, with that set analysis it highlight the first "Valeria" and "Caterina"

How can I do?

[Lech_Miszkiewicz]

Hi,

you are saying that you want to highlight only the second instance when Valeria name is present?

If(count(Total<Name> Name) > 1 and aggr(min(total <Name> ID),Name)<>ID,red())

 cheers

[Anil_Babu_Samineni]

try this - if(count(Total <nome_utente> nome_utente) > 1 ,Red())