Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Hi Rosie,
look at this approach using the script.
Probably, thinking on a little bit more it's better.
Andrea