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%'

      END

       

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

      category.png

      But I want output as below

      output.png

      Any help !!!!