Hi Experts

I have a requirement as below, Kindly help me to fix this.

Normal Output
Partner Role

SAP A
SAP B
SAP C

Expected Output

Partner Role

SAP A,B,C

Here SAP has three different rows in database, But in calculation view I need to display them as a one single row in HANA.

Can some one help me to achieve this ??

Thanks

Rufus Samuel