I have a dataset showing customers' product holdings in two time periods, 2017 & 2018.
Each customer has two rows (one for each year) and each row contains customer ID, product holding and value - see a very simplified table below.
I need to filter customers based on their 2018 product holding, but return both of the rows relating to the relevant customer. E.g. based on the data table above, I'd like to filter customers where their 2018 product holding is 'X' and return the following rows.
I've attached a packaged workbook with the same data in. How can I go about filtering customers based on the product in the relevant 2018 row?