Hi Folks,
Sorry for this basic one, I am a newbie to pivot table.
I am running an excel report with various column and row labels as below. What I am trying is to create a pivot table to filter those names who are using ONLY these products "apple" and "lemon", however not anyone who are using "orange" and "grape".
For example: jason is using apple, however he is also using orange, so he needs to be excluded.
So expected result is: tim, tom, adam since all of them are using only those products, and not anything from the exclusion list. I tried with pivot but returning a result with mix of names, what should be right flow of filters and row labels to use here?
name product
------ --------
jason apple
jason orange
tim lemon
lucy grape
tom apple
adam apple
jen lemon
jen grape
luke lemon
luke orange
luke apple
Bookmarks