seeing duplicates across two fields

[#1]

I have three fields supporter number, last name and postcode. What I am trying to do is to put a condition on the background colour of supporter number to say if the postcode and last name combination appears twice i want the supporter number to be coloured.

I understand where to put this condition but I cannot work out what condition to use

thanks in advance

Rosie

[#2]

I think I may know what my problem is do I need to keep the key dimension in the chart for the calculation to work?

Thanks

Rosie

[#3]

in the small example data I don't see any change, but can be that you have something in the real data.

Make the key using a trim.

Another approach can be done in the script.

Let me knoe if you can solve this issue.

Andrea

[#4]

Hi Rosie,

look at this approach using the script.

Probably, thinking on a little bit more it's better.

Andrea