Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
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.
Please help
Thanks
Hi,
Change it to like this
if(perm_staff = 'Pay a', blue(), if(perm_staff = 'Pay b', Yellow().....
Celambarasan
Hi Celambarasan, I have already tried that and it does not work.
Hi I think I've sorted it by changing perm_staff to 'Pay level'
Thanks all that had a look.