Is there a 'join' function in the reports?

[YvetteLans]

Hi,

I have one order of € 3.000 which contains 2 products, Product B and Product C.

The goal is to show it in the report as

14 Oct 2024 - € 3000 - Product B / Product C - John Doe

Currently the report shows the following information.

Normally I can do a ‘Join’ in a formula to show Product B and Product C in one line. But I can’t find such option in de reports.

Does anybody know the magic tric?

[Chr1sG]

Try TEXT_AGG()

[YvetteLans]

@Chr1sG

TEXT_AGG()

Thanks!