pivot dimension background color without expression

[Anonymous]

Dear Community,

we noticed that if we use a pivot without an expression, we can not set the background color of dimensions.

Is there any possibility how to achive that?

We need the pivot as it groups fields, but we dont have an expression. Maybe hiding an dummy expression would be a solution?

[#2 · Accepted solution]

first go to settings>document properties>general and check that styling mode is set to  advanced.

now right click on pivot table > select custom format cell>click on background colour and choose colour

hope this works

[buzzy996]

see this,

[Anonymous]

Hi Shiva, your example has a expression, thats what we dont want!

[Anonymous]

Hi Sana, your answer is correct, you just forgot to mention that we have to active "Design Grid.

Thanks!

[buzzy996]

ur right,but the background color is applied only for dimensions objects..so u can do the same on ur pivot table whether ur have expression or even if u don't ve expression.

[Anonymous]

Thats the point if you dont have an expression it will not work...

Then you have to use "custom format cell", which was mentioned by Sana.

[buzzy996]

ya,even tht's other option..i never tried with out expression..so i thought it'll works

[Anonymous]

If we now use an expression for the background color (matching value of row) of the custom format cell, and the expression matches a value in one row, all rows get colored.

Is there any way how we can achive this, that only the row with the matched value gets colored while using custom format cell with an expression?

[#10]

Custom Format cell only used to color the Header fields only (Table Field Name BG)