3 Replies Latest reply: Aug 10, 2011 8:41 PM by doschafe RSS

    How to NOT set the color of the Expression Heading in Pivot table

      An expression is  being used in my pivot chart.  For the Text Color of one of the Expressions, I am also using an Expression.  However, it is changing the color of the expression heading or Label as well, how to  avoid changing the colomn label for the expression as well.


      The Label is called:  TestExpression


      The formula for Text Color in the pivot table is: 


           if(       (SUM(If(Phone='superphone', Results))) =0           ,rgb(255,0,0)                                                                                                                    )