2 Replies Latest reply on Jun 19, 2018 2:51 PM by Deepak Rai

    Distinct Count based on condition

    Erick NIZARD

      I have an opportunities data file coming from my CRM system.

      It has 1 row per opportunity.

      A given client can have more than 1 opportunity.

      It also has the status of the opportunity i.e. Won, Lost or Open.

       

      I can easily calculate the number of distinct clients that have at least 1 opportunity using COUNTD([AccountCRMID (Opportunity)]).

       

      However, i am trying to calculate the distinct amount of client that only have Lost opportunity and i'm somehow stuck

       

      Any lead will be truly appreciated