No background color in pivot table without expressions

[pennetzdorfer]

Hi,

I'm using a "pivot table" without expressions (having disabled "Suppress Zero-Values" in the Presentation tab). So far, so good.

Now, I'm trying to add a background colour for the first column: Dimensions tab >  expand first dimension > Background color =rgb(255,255,0)

However, the background colour won't appear until I add at least 1 expression (which I want to avoid in this specific case).

Any ideas? Thanks in advance!

PS: I'm using QV11 SR1

[#2 · Accepted solution]

Did you try custom format cell?

[pennetzdorfer]

Thank you, Frank - it works!