I have a straight table chart with a dimension in which I would like to only return specific values. I tried doing the following:
=If([Country] = 'USA', 'CANADA' [Country]
However, this still returns other countries. How can I limit my results to just USA and CANADA?
Try this :
=if([Country]='USA' or [Country]='CANADA',[Country])
Also, Make sure Show All Values is unchecked.
Retrieving data ...