My Aim is to get the Transaction colour same if the SAPRole Name is same.
I have this chart and I am trying to change the colour of Transaction based on SAPRoleName
SAPRole Name is Label for the field [Text role_RTEXT]
So I am trying in the Dimension Transaction-> Textcolour
and giving the following Expression
= IF([Text role_RTEXT] = above([Text role_RTEXT]), LIGHTBLUE(), LIGHTGREEN())
It shows the same colour as in the above diagram.
Any idea how to get different colours?