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:
|BizTech||Accessories,Accessories,Access||193,394||2012 Week 15||2012 / 04|
|FunPod||Camera,Camera,Camera,Camera,Ca||139,505||2012 Week 15||2012 / 04|
|HomeView||Install,Install,Install,Instal||147,154||2012 Week 15||2012 / 04|
If you notice, the product type values are repeated in second column. Any thoughts on how to get unique values?
thanks in advance