IBM cognos analytics 11.1 group_cocat

Question

I have a Table with three string columns (ID, name, books).If I wrote SQL, I would want the result of the following query:

SELECT ID
, name
, group_concat(books) as concat_groups
FROM Table
GROUP BY ID
, name

However, I cannot write an SQL query and have to use a 'drag and drop' query from a table that is a part of a preloaded data model. I do not find any function to concatenate strings in the summarize properties.