0 Replies Latest reply on May 2, 2013 4:52 AM by Ambi Nair

    Display all the created values of range

    Ambi Nair

      hi,

      I have created unit price with this formula "SUM([TOTAL AMOUNT] )/SUM([QUANTITY] ).

      and created range upon it as below.

       

      if [Unit Price]>0 and [Unit Price]<=2000 then '<2k'

      elseif [Unit Price]>2000 and [Unit Price]<=5000 then '2k-5k'

      elseif[Unit Price]>5000 and [Unit Price]<=10000 then '5k-10k'

      else '>10k'

      end

       

      However when i drag this range on to column shelf i m able to see only "<2k".refer sheet 2.idea is to create bar chart.

      Hence not able to look into % of customers which fall into different range.

       

      Attached is the dummy file.Please help

       

      regards

      amby