Column title color in pivot table with text color expression property

[#1]

Hi all!

I have an expression in a pivot table that is formatted using "text color" option on expression properties. Depending on the expression value, we show values in red or blue color. It works perfect but the column title color changes too. We want to have the column title in white and the expression values in red or blue.

"Custom format cell" doesn't work because expression color properties seem to override the format values.

Any idea?

Thanks!

[stephencredmond]

Hi,

You could try including an If statement incorporating the Dimensionality() function.

Stephen

[#3]

When I took a similar question to QlikTech support last year I was told that it is "working as designed". The title seems to take on the color of the "top" cell in the column. It wasn't a big problem for my project so we just decided to ignore it. Sorry I don't have any useful advice.

[#4]

Seems to be Tim is right. It takes the color of the first cell. Now if you are that particular that color should not change, try creating a text field and place it over the cell. Not a good idea if you allow to minimize the chart.

[#5]

Thanks!

I'll try with the text field... It seems to be the best option.

[#6]

Same here,

color of first line or cell. Seems a problem for us in many terms of use. Don't know how to work around!? Seems like a bug and QV show this like a feature. Nice...

Greetings,

Jonas

[johnw]

A fix was requested back in 2009 on the Customer Portal. So far it only has three votes. If you want it changed, vote for it! 🙂

https://emea.salesforce.com/ideas/viewIdea.apexp?id=08720000000GnlS&srPos=0&srKp=087