6 Replies Latest reply: Nov 12, 2012 7:43 AM by Peter Brunner RSS

    Count with Set Analysis per Month

    Peter Brunner

      Hi Guys,

       

      I am trying to Count number of    New Customers Accounts, Per REP per MONTH,  .

       

      I am only selecting different MONTHS from List box as the rest is Set analysis.

       

      I am missing something here as I can only can get an aggerated amount of New Customers per REP up to MONTH Selected ?

       

      I have a table  with =   NewCustDate,  Rep, CustomerNo, CustStat

       

      the NewCustDate , Date format =YYYYMMDD and  Data Starting from 20120701

       

       

      My Expression 

      Count({$<Rep={'HARRY'},CustStat={'20'}>}CustStat)

       

        I have tried this Expression as well but give same results as above

      Count ({$<CustomerNo=p({$<Rep={'HARRY}>}CustomerNo)>}Month(NewCustDate)

       

      any help appreciated

      regards Peter