Colour coding in a matrix

Question

User757116521 posted

I have a matrix with a column group of Job Level, with a child group of Course Type.

There can be up to 4 Job Levels. If the Course Type is Classroom, the colour of the cell(Fill Colour) should be blue. If the Course Type is eLearning, the colour of the cell should be green.

I have put conditional code in for this as follows:

IIF(Fields!CourseType.Value = "Classroom",Blue,Green)

However, if a particular row of data does not have any data for Level 4 for example(Course Type = NULL), then the cell will be Green. This is fine for the eLearning column, but obviously not for the Classroom.

Does anyone know how to get the report to recognise what Course Type the column is grouped on?

 

 

 

 

 

 

Answer 1

User-830595639 posted

Hi,

You are using single IIF, for multiple condition, you need to use multiple IIF or a switch for multiple condition like below.

IIF(Fields!CourseType.Value = "Classroom",Blue,IIF(Fields!CourseType.Value = "eLearning",Green,""))