List with shops offering Min or Max price

[Anonymous]

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

[danielrozental · Accepted solution]

I believe the aggr is missing the shop

=Concat(

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

                         shop,product,price),

',')

[Anonymous]

A lot of thanx, Daniel!

The solution was too simple

[rohit214]

hi,

can you explain each term in your expression i am not able to get it

thanks

rohit