1 Reply Latest reply: Jul 5, 2012 9:50 AM by Stefan Wühl RSS

    Automatically subdivide prices

      Is there a possibility to automatically subdivide different prices of a product into 5 separate price ranges?

      i.e. (highest price-lowest price)/5 = price difference --> lowest price + price difference= first price range

      Thanks for your help!

        • Re: Automatically subdivide prices
          Stefan Wühl

          Should be possible by creating two variables for min and max price:

          =min(PriceField)

          =max(PriceField)

           

          then using a calculated dimension:

          =class(PriceField, (vMaxPrice-vMinPrice)/5 ,'x',vMinPrice)

           

          and as expression what you like, e.g. count(distinct SupplierCompany)

           

          Regards,

          Stefan