Filter columns based on multiple criteria, retaining all

[schaeefer]

I have a dataset with 3 columns -

1. Customer

2. Product

3. Amount

There are multiple products and I want to filter to see if Customer has product X what other products do they have i.e. if they have product X and value is not 0 what other lines of data for that customer are in the dataset.

i don't want to just filter on product X I also want to see all the lines of data for Customers who happen to have product X

[Felipe_Ribeir0 · Accepted solution]

Hi @schaeefer 

If i understood correctly

1-You can filter product = X, then you will have all customers that bought it.

2-You can join 1 with your dataset by customer