I am not sure how to put this in words, so I am attaching an Image. I have two columns (I have many more but two is enough for example here) in my tablix. And there are two Row Groupings as in attached image. I need to color the column two with different colors based on one color for each value in column 1.
In example there are three values, A,B,C, but in my actual report there would me many value(>50) and so I cannot use SWITCH expression for background color.
It would be nice if I could increment some value to change the color, instead of hardcoding 50 color names...
Please help.