3 Replies Latest reply on Dec 22, 2016 4:32 AM by keerthana kumar

    category wise count(customers)

    keerthana kumar

      Hi All,


      I have scenario as below where i have to categorize customers as per their profit ratio

      i need count of customers who fall under each category where category is calculated as below:


      if [Profit Ratio]>0.35 then '>35%'

      ELSEIF [Profit Ratio]>=0.25 and [Profit Ratio]<=0.35 then '35% - 25%'

      ELSEIF [Profit Ratio]>=0.15 and [Profit Ratio]<0.25 then '25% - 15%'

      ELSE '<15%'



      i am able see the achieve this but able to get count of customers category wise


      But I want output as below


      Any help !!!!