I want to color code age field based on color name in string format dynamically.
my report looks like this.
Here, I made a calculation with case statement and placed on color. But it is choosing color by default and also not by color field. I have to assign every time when a new color is added to table. I want to make it dynamic, like if we add a new color ex: purple it should auto reflect purple color.