multiple selections in GetFieldSelections + Set Analysis

[ZuzJsk007]

Hi, I'm using following expression to show only such ProductNames for which the CategoryName has been selected within filter pane "CategoryName":

=aggr(only({<CategoryName={'$(=GetFieldSelections(CategoryName))'}>} ProductName), ProductName)

But it doesn't work when I select more then 1 CategoryName. (no Product appear in the filter pane)

Is there any way how to do it?

I really appreciate any help. 🙂

[GaryGiles]

Try this:

=aggr(only({<CategoryName={$(=if(GetSelectedCount(CategoryName) > 0,concat({$} chr(39)&CategoryName&chr(39)),','))}>} ProductName), ProductName)

[ZuzJsk007]

Unfortunately it doesn't work - it only works for one Category selection, not more

[GaryGiles · Accepted solution]

I misplaced a ")".  Try this:

=aggr(only({<CategoryName={$(=if(GetSelectedCount(CategoryName) > 0,concat({$} chr(39)&CategoryName&chr(39),',')))}>} ProductName), ProductName)

[ZuzJsk007]

Perfect! Thank you so much!:)