2 Replies Latest reply: Dec 23, 2012 9:50 AM by Business Intelligencelal El-Abd RSS

    Count for specific values

      I have the following table


      department       Overall Satisfaction

      ---------------       ------------------------------

      Inpatient            Extremely Satisfied

      Inpatient            Satisfied

      Outpatient         dissatisfied

      Inpatient           dissatisfied

      Outpatient         Satisfied






      I want to get the following formula ( Extremely satisfied + Satisfied) of inpatient / Count( department = 'Inpatient)