SOLVED
Filter columns based on multiple criteria, retaining all
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
schaeefer
5 - Atom
‎08-08-2023
09:58 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
Labels:
- Labels:
- Preparation
- Workflow
1 REPLY 1
Felipe_Ribeir0
16 - Nebula
‎08-08-2023
10:14 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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