Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
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.
Awesome! works like a charm! Thanks a lot:)