This content has been marked as final. Show 3 replies
I have created a pivot table with two dimensions e.g department, pay level and some expressions e.g current permanant workforce, Temp, etc. Now I have dragged pay-level under the expression. What I am trying to do is formulate an IF statement so that each pay-level (the whole column say under Permanent staff) will be different colours. The following doesn't seem to work.
if(perm_staff = 'Pay a', 'blue()', if(perm_staff = 'Pay b', 'Yellow ()'.....
I have written this statement under background colour of Perm_staff.