color pivot cells

[#1]

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

[el_aprendiz111]

Hi,

1-Example

[#3]

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

[el_aprendiz111]

Hi,

[johnw]

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.

[johnw]

Unfortunately, Volume isn't a category - it's the label for an expression.