SELECT function help

[Remco_Edelenbos]

Hi all,

I have a checkin app. It contains 3 tables.
1: Checked-in
2: Ref-Barcode
3: Ref-Upsells

In the Ref-Barcode table is an CustomerID and in the Ref-Upsells is also an CustomerID column. In the Ref-Upsells is a colmn: “Type” in this colmn is the list of the upsells the customer has orderd.

I’ve made a virtual colmn in the Checked-in table. When i scan the ticket it pulls the data from the Ref-Barcode table. I want a list with corresponding upsells in the form. This is my formula:

SELECT(Upsells[Type],[CustomerID] = [CustomerID], TRUE)

Now i get list with every unique upsell. But not sorted based on the Customer.

[Aleksi · Accepted solution]

It sounds that you are looking for SELECT(Upsells[Type],[_THISROW].[CustomerID] = [CustomerID], TRUE)