xcellerator
New Member
- Joined
- Feb 22, 2017
- Messages
- 23
- Office Version
- 2019
- Platform
- MacOS
I have a pivot table (Excel for Mac), where I have buyers in the rows, then products in the columns. The field values are $ paid.
I have added a filter for a certain set of products. What I would like to do is to keep the list of individuals that bought one of those products in that pivot table (it is a long list...hundreds), and then remove the product filter, and continue to see those same customers only but also now what what else they purchased. Hopefully that makes sense.
An example would be:
I've filtered on red bicycles, and see all customers that bought them.
Now what I would like to do is keep that list of customers only (don't show any other customers), but remove the product filter, so I see everything they purchased (the red bicycle, PLUS helmets, tires, water bottles...). So the list only includes customers that purchased red bicycles.
I know how to do this in other applications, but not sure how with a pivot table.
Thank you
I have added a filter for a certain set of products. What I would like to do is to keep the list of individuals that bought one of those products in that pivot table (it is a long list...hundreds), and then remove the product filter, and continue to see those same customers only but also now what what else they purchased. Hopefully that makes sense.
An example would be:
I've filtered on red bicycles, and see all customers that bought them.
Now what I would like to do is keep that list of customers only (don't show any other customers), but remove the product filter, so I see everything they purchased (the red bicycle, PLUS helmets, tires, water bottles...). So the list only includes customers that purchased red bicycles.
I know how to do this in other applications, but not sure how with a pivot table.
Thank you
