How to combine two different rows into a one Single row in HANA Calculation View.

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