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
