Rollingup data for a Dimension in SAP Analytics Cloud

[Sumalini]

Hi All,

I have a requirement to rollup data in SAP Analytics cloud, based on complaint number, i have to concatenate the code values.

 I couldn't find the way to acheive this using Calculated Dimension, i tried writing the script, but no luck.Could someone please help me on how to acheive this.

ComplaintNo	Code	Product name
CN-1	A01	P1
CN-1	E034	P1
CN-1	F15	P1
CN-2	A25	J1
CN-2	G07	J1

Output should be like the below.

ComplaintNo	Code	Product name
CN-1	A01;E034;F15	P1
CN-2	A25;G07	J1

[SAP1410]

If you are presenting in Excel, please use excel VBA script to archive it.

[Sumalini]

Hi, Thanks for your reply. I'm not using excel add-on for SAP SAC. I'm designing reports in SAC Story page