Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
i need help with colouring cell as below ('Sales' and 'Margin' for every region). What i can do is only color the expression, but the name needs to have the same.
Can someone help me please? File is attached.
Thanks a lot
Tommy
Hi,
1-Example
Hi this is not what i need,
I need to color cell with text 'Sales' and 'Margin'.
Not the values and not the header.
Thanks
Tommy
Hi,
In case someone can learn something from my failure, I tried it like this:
Expressions:
LOAD
dual(Expression,recno()) as Expression
,rgb(R,G,B) as Color
INLINE [
Expression,R,G,B
Volume,255,255,255
Sales,255,255,153
Margin,205,205,153
];
Chart expression = pick(Expression,sum(Volume),sum(Sales),1)
Background color expression = Color
But it fails because there isn't data in all the cells, so Color is often undefined, so cells that should be colored are white, and it looks worse then where we started.
Unfortunately, Volume isn't a category - it's the label for an expression.