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 :



      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?