Forum Discussion
Anonymous
7 years agoNot applicable
Colour coding in matrix based on different column
Hi Is it possible to colour whole columns in a matrix and not the actual values. I have items being sorted into buckets, 0-2, 3-10 and 11-25. There is a count of items in the values but I don't w...
Anonymous
7 years agoNot applicable
Hi
Thanks for your response. I only see one field that I can select the Count and not the "Bucket" field which I need.
i'm using RS Version: 2.61.5192.641 64-bit (August 2018)
Is that an old version?
Anonymous
7 years agoNot applicable
It is yes, although the feature should exist in your version. What you need to do is find the value column that you want the colour to exist in. Click its drop arrow and select Conditional Formatting. Inside that window will be the "Based on Field" option that will allow you to specify what the conditions are to colour your results in the matrix. In my example below, OPH is in my matrix and i've specified rules around OPH, however you could select with the dropdown, any other field in your model