5 Replies Latest reply: Feb 23, 2017 7:29 AM by Rahul Pawar RSS

    Sum If Condition


      Hello all!!!


      I need help,  i have the above expression but it doesn't work...


      if(YEAR='2016' and Store='FO Type 5', sum(TOTAL PARTPATT='5 ΕΜΠΟΡΕΥΜΑΤΑ FO'[Net Sales]))


      All the green fields are dimensions.


      I want to make that calculation..

      if year =2016 and store=FO Type 5 then calculate the Total sum of Net Sales but for a different dimension wich is PARTPATT=5 ΕΜΠΟΡΕΥΜΑΤΑ FO


      Thank you very much in advance!