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:
<tbody>
</tbody>
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.
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 |
<tbody>
</tbody>
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.