I have a pivot table, each company may be selected for up to 5 categories,
lets say apples, oranges, bananas, kiwi and grape. I have selected all
companeis who have ticked apples and grape, but the pivot table show all
which have apples or grape or both. I only want to see those which have
both. Any ideas?