Text color in Pivot Label with Set Analysis

[alan_grn]

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?

[swuehl · Accepted solution]

Try

=if( only({<DisplayProduct = {1}>} ProductName) ='Widget',White(),Black())