Hi,

I am trying to create a column which returns aggregated values separated by comma. I am using EVALUATE_AGGR and LISTAGG function.

To elaborate, I am using Sample App Lite RPD. I created a report with Month, Brand, Product Types and Revenue columns. Product Types column has following formula:

cast(EVALUATE_AGGR('LISTAGG(%1,%2) within group ( order by %1 ASC)',  "Products"."P2  Product Type",',') as char(1000))

The result is:

If  you notice, the product type values are repeated in second column. Any thoughts on how to get unique values?

thanks in advance