3 Replies Latest reply: Oct 24, 2016 2:51 PM by Massimo Grossi RSS

    Translating to set analysis

    Liam Hanninen

      If I want to only see sales from Canada I would do this in set analysis:

       

      sum({<Country={'Canada'}>} Sales)

       

      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?