Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Try
=if( only({<DisplayProduct = {1}>} ProductName) ='Widget',White(),Black())
Try
=if( only({<DisplayProduct = {1}>} ProductName) ='Widget',White(),Black())