Hello,

I am trying to get at some cross buying behavior from a large data set that I have. Here is simple, example of the Pivot Table I have put together so far:

Brand A Brand B Brand C Brand D
John 1 2
Mark 1
Amy 1 1

Essentially I am trying to put together a grid that shows the number of instances where someone buys both Brand A and another brand. Is there a formula that would get at this? Thank you.