Aggregation (String)

[riceball]

Hi,

I've encountered some aggregation issue for my expression line in pivot table. Would appreciate some help from you guys

I would like my result to look like this (please see highlighted cells).This column will reflect my product name based on the category='Main' group by Country and Brand

Thank you very much!

[Gysbert_Wassenaar · Accepted solution]

Try:  if(Category='Main',Product, aggr(NODISTINCT concat({<Category={'Main'}>}DISTINCT Product, ' & '),Country,Brand))

See attached example.

[riceball]

It works wonders! Thank you so much for your help!!!

[riceball]

Hi,

I wonder if there is any way I can load the expression into the script? I would like to have a listbox whereby my user can select the product name and the desired result (e.g: If Product A1 was selected, the listbox will show A4&A9 as possible selection)

I tried using resident load group by function but it doesn't seem to work.

Thanks!