Set Analysis + custom Filter pane

[ZuzJsk007]

Hi, I have following filter pane :

=if(Flag_Return = 1, CustomerName)

named CustomerName

I want to create a dimension in a table - show only such OrderIDs which belong to that specific customer selected in the filter pane above. I used:

=aggr(only({<CustomerName={'$(=GetFieldSelections(CustomerName))'}>}OrderID), OrderID)

but this only works when I use purely "CustomerName" in the filter pane (not the function)

Any ideas please?

[GaryGiles · Accepted solution]

You can use this in the Filter Pane:

aggr(only({1<Flag_Return={1}>} CustomerName), CustomerName)

Then, you should be able to have the OrderId as-is in your table.  If you only want to show OrderIds when a selection if made, you could use:

If(GetSelectedCount(CustomerName)>0,OrderId)

or Show/Hide the Field based on if any values are selected.

[ZuzJsk007]

Awesome! works like a charm! Thanks a lot:)