1 Reply Latest reply: Sep 12, 2016 7:43 PM by Sunny Talwar RSS

    Using set identifier with multiple set analysis

    Kenneth Edwards

      Maybe its just the syntax that's screwing me up.  My issue is i want to do the set analysis say for Year=2016, and Month=Jul, exluding all selections.

       

      Sum({1<[Year]={'2016'}>*<[Month]={'Jul'}>}Sales)

       

      This behaves the same way with or without the 1.  The year and month sets work on their own, and if i combine the 1 with only one field of set analysis it works, but not all at the same time.

       

      Any Ideas?

       

      Thanks