2 Replies Latest reply: May 19, 2016 11:34 AM by Franco Jofré RSS

    Setanalysis con 2 condiciones

    Franco Jofré

      Hi guys, i need your help with the next expression:

       

      I want to sum all the sales of the week from the past year, considering the year and week that i have selected on my filters.

       

      To get a week before of the current year, im using this expression. I guess i would have to add some "Year -1" in some place, but i can't get to the answer.

       

      sum({ $<[Week]={$(=only([Week])-1)}> } Sales)

       

      I appreciate your help.

       

      Regards.