Skip to Content
Mar 04, 2019 at 05:27 PM

Mutiple values onto one row


Hi All,

Fairly new user to webi reports and require some help.

I have trying to create a variable to get multiple columns values onto the same row, so my report does not create multiple ID rows for each value e.g.

ID Subject System Impact

1 abc Tableau

1 abc Excel

1 abc BusinessObjects

I created a variable which works if I filter for just one ID but not when all are brought in:

=[Content] Where ([Name] = "Systems Impact") In Report

I would like the output as:

ID Subject System Impact

1 abc Tableau, Excel, BusinessObjects

Hope this makes sense.