10 Replies Latest reply: May 4, 2017 11:25 AM by Sunny Talwar RSS

    Set analysis: exclude two or more of conditions

    Nikolay Melenchuk

      I have to exclude from all range of possible values combination of two in measure. Basically I need to sum all but year 2016 and month 5 and Total for field Amount should be 9.

      I need solution with set analysis as in real data there are much more combinations and more conditions.

      For example:

      YearMonthAmount

      2015

      51
      20165

      2

      2015

      4

      3
      201675

       

      at the moment tried something like this but it doesn't help

      Sum({-<Month={5}>*<Year={2016}>} Amount)

      Sum({$-<Month={5}>*<Year={2016}>} Amount)

      Sum({$}-{<Month={5}>*<Year={2016}>} Amount)

      Sum(-{<Month={5}>*<Year={2016}>} Amount)


      So the question is really about syntax.