This content has been marked as final. Show 3 replies
If I want to only see sales from Canada I would do this in set analysis:
similarly (but not ideally) I could do;
if (Country='Canada', Sales)
Now if I only want to see sales from this last year (YTD) I might do:
if( min(%Date)>(today()-365), Sales)
What is the set analysis equivalent of this?