1 Reply Latest reply: Nov 6, 2015 11:44 AM by Stefan Wühl RSS

    Text color in Pivot Label with Set Analysis

    Alan Green

      I have a pivot table with the following :

      Dimension : ProductName

      Expression :=Sum({$<DisplayProduct ={'1'}>} Sales )

       

      With the above it only shows the products which are tagged as DisplayProduct = 1.

       

      I then add to the expression Text Color :

      =if(ProductName='Widget',White(),Black())

       

      The table then changes and displays items even where the DisplayProduct flag is not equal to 1.

       

      What do I need to do to get this to work?