7 Replies Latest reply: Oct 24, 2013 8:00 AM by Marco Imperiale RSS

    It's hard!!

    Marco Imperiale

      I want to count the unique CONTACTID for this first half year, with a LastYear SALESVALUE>3000$, I do in this way:

      =COUNT({$<

      F_TYPE={'A'},

      YEAR={2013},

      MONTH={"<=6"},

      SALESVALUE={">0"},

       

      CONTACTID={"=SUM({$<

      F_TYPE={'A'},

      YEAR={2012},

      MONTH=

      >} NETSALEBUDGET)>=3000"} 

      >})

      >} DISTINCT CONTACTID)

       

      The question is: all seems to be ok, but, when I use this formula in a grid, the sub SUM() (in bold) function seems to count every unique CONTACTID of the whole world and not only for the region code of the dimension line......... how can I correct this?