1 of 1 people found this helpful
What you will need to do is create a LOD calculation to count the total number of rows before filters.- calculation 1
and then create new fields for each of your colour fields
which would be if number of rows = calculation 1 then colorfield else 'No Color'
hope this makes sense
if you need help with this let me know and I can find some time later today or tomorrow morning to assist you
Great idea - thanks Khalid !