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


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



      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