Hello friends, I'm trying to group the dataset as shown below, but I'm not getting it. I think it's possible to use a custom key, but I don't know which SQL Expression to use. Has anyone ever had to do something like this?
order | product | value
100 | product A | 10.00
100 | product B | 5.00
order | concat_product | sum_value
100 | product A, product B | 15.00
[Edit]: Solution (Image)