1 Reply Latest reply: Apr 4, 2016 10:28 AM by Sunny Talwar RSS

    Set Analysis Filter to filter 2 criteria

    Asaad Saleh

      Hi,

       

      I need to count data where 2 criteria to be met, 1 the Year and the Account Manager Name

      i'm currently using the below to have the Account manager name filtered to count the data which is here the number of Topics in CRM.

       

      Count(if(Owner='John Smith',Topic))

      OR:

      Count({$<[Owner]={"John Smith"}>} Topic)

      i need to be able to add the Year or another criteria to that formula.

       

      thank you for your help.