# Is there a 'join' function in the reports? **URL:** \ **Category:** Get Help\ **Created:** [October 14, 2024, 7:04am UTC](https://community.fibery.io/t/is-there-a-join-function-in-the-reports/7556 "2024-10-14T07:04:23Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![YvetteLans](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/yvettelans/32/6101_2.png) [@YvetteLans](https://community.fibery.io/u/YvetteLans)\ **Post date:** [October 14, 2024, 7:04am UTC](https://community.fibery.io/t/is-there-a-join-function-in-the-reports/7556/1 "2024-10-14T07:04:23Z")
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. ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/0/0fd9e7b4ee52b12aedc132f6e10d639dbba19e19.png) 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? 😅 ---
**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\ **Post date:** [October 14, 2024, 9:52am UTC](https://community.fibery.io/t/is-there-a-join-function-in-the-reports/7556/2 "2024-10-14T09:52:34Z")
Try `TEXT_AGG()` ---
**Author:** ![YvetteLans](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/yvettelans/32/6101_2.png) [@YvetteLans](https://community.fibery.io/u/YvetteLans)\ **Post date:** [October 14, 2024, 10:01am UTC](https://community.fibery.io/t/is-there-a-join-function-in-the-reports/7556/3 "2024-10-14T10:01:59Z")
> [@Chr1sG](#): > > TEXT\_AGG() Thanks! 🥳🥳 ---
**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\ **Post date:** [October 14, 2024, 10:45am UTC](https://community.fibery.io/t/is-there-a-join-function-in-the-reports/7556/4 "2024-10-14T10:45:42Z")