3 Replies Latest reply: Jan 18, 2013 8:12 AM by rohit gupta RSS

    List with shops offering Min or Max price

    Artjoms Tukums

      Hi everybody,

       

      There is a need to have a comma separated list of shops offering minimal and maximal price of a product.

      It is quite simple to get min and max prices, but difficult to get corresponding values in other field

       

      The expression

      =Concat(

           DISTINCT aggr(if(price=Min(total<product> price),shop),

                               product,price),

      ',')

      works only if there is just one shop with minimal price. No shop list in case several shops with equal minimal price

       

      Any advice will be helpful!

       

      See example attached

       

      Rgds,
      AT