6 Replies Latest reply: Oct 22, 2012 4:10 AM by Axel Gustafsson RSS

    QV11 Text Color format not working in pivot table

    Mike 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