I should know the answer to this, but I seem to be having a problem with a solution, basically I have a straight table of only 3 rows, and I want to conditionally colour code (text) the 2nd and 3rd row field 1 based on how they compare to Row 1 field 1 e.g.
Row 1 field 1 stays black,
If Row 2 field 1 is greater than Row 1 field 1 then colour is red , if same then orange else green.
There is a single dimension that is used e.g. Category , so in effect I am testing the values across the dimension rows.
I don' want to write the calculations i.e. the SUM's etc into the colour condition as this becomes clumsy.
This expression evaluate the previous value, if it's not null it will check if the current value is greater or equal than the previous and apply the corresponding color code, otherwise font will be black. Here is an example of the output of this function: