Color in pivot table

[#1]

Hi all,

I have a pivot table that looks similar to

group                     Min_group         0-15    16-30    31-45      45-60                  

major                                              0           5           2            3                          

minor                                              6           1           4            2

when minutes is 0-15 and 16-30 and 31-45 i want the values of major and minor to display RED color and for 45-60  in GREEN.

I tried to  change color's in visual cue tab but it only shows expressions. Group and Min_group are my dimensions and not expressions so after selecting dimension (group), clicked on + sign and in background color I wrote the expression

If(group = 'major' and Min_group = '0-15', group = RGB(255,0,0))  --> Didnt work so I changed it to

If(group = 'major' and Min_group = '0-15', RGB(255,0,0)) ---> Didnt work. 

[Gysbert_Wassenaar · Accepted solution]

This one works for me:

if(group='major' and Min_Group='0-15',rgb(255,0,0))

See attached qvw

[#3]

Nope. Doesnt work. Cant understand what the issue is.

[#4]

It worked. When I grouped them in the load script, it assisgned as '0 - 15' and etc. That space between 0 and - and - and 15 was the problem as I was calling it in the expression as '0-15' rather than '0 - 15'.

Thanks.