4 Replies Latest reply: Sep 9, 2010 10:07 AM by JurajChovan RSS

    Pivot table: set color of value in ColumnA depends on value in ColumnB

      hi friends,

      is it possible to set behavior of value in column "A" on pivot table to following rules?:

      - pivot table (chart object)

      - dimensions: year, month, business case (string), deliverable (string)

      - expressions: weighted total (in €), total (in €), invoicing probability (in %)

      if value "invoicing probability" in row is less than 100 (%), I would want to set color (font) for value "weighted total" to RED. Else value will have GREEN font.

       

      very thanks for tips