Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table with the years as columns and the client name as rows. I now want that the text color is green when the sales are higher than previous year and red when they are lower.
There is also a totals column which I want to remain black.
Someone who have done this before?
Thanks in advance
You seem to be doing this in a pivot table, right? You can use Before/After function to compare one year to another year. Take a look here:
Thanks, it worked!
Do you have an idea how i can exclude the totals this color function?
You can use Dimensionality() function to exclude the above color calculation for totals
The second dimension... or how to use secondarydimensionality()