Text color in Pivot Label with Set Analysis

alan_grn — Fri, 06 Nov 2015 16:42:16 GMT

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?

Re: Text color in Pivot Label with Set Analysis

swuehl — Fri, 06 Nov 2015 16:44:01 GMT

Try

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