QV11 Text Color format not working in pivot table

[Michael_Reese]

I have a field for each color, R, G, B.  These fields are attributes of dimesnions values.  Each field value has it's own R, G and B components.

The text format is RGB(R,G,B). 

This works fine in straight tables.  In pivot tables, it only works with the dimension value in rows, not columns.  I need columns.

I also tried custom format cells and the calculated condition keeps setting itself back to fixed.

Any alternatives? 

Thanks

[Anonymous]

try chnaging it in visual cues

[Michael_Reese]

Unfortunately, I need to format the dimension value, not the expression.

[jdf]

I am running into this issue as well. Have you found a solution?

Thanks,

Jake

[Michael_Reese]

It shoud be fixed in SR2.

[#6]

I am also stucked up with the same Issue. Even if we hard coded with a particular color, It is not working. Is there any solution for this

[atafsson]

You can Format cell, only aviable in Advanced Layout level. Then you format all the dimensions to the same color.

Activate Advanced Layout level under document properties. Right-click on the cell (on of the dimensions) and chose 'Format cell'.

You can do a calculated color with your fields RGB(R,G,B).

Hope it helps.