Good night people!
I would like some help to develop some technique to find how many combinations I have within an existing list.
Example:
ORDER A - ITEM 1
ORDER A - ITEM 4
ORDER A - ITEM 8
ORDER B - ITEM 4
ORDER B - ITEM 1
ORDER C - ITEM 4
ORDER C - ITEM 8
ORDER C - ITEM 5
ORDER C - ITEM 3
ORDER D - ITEM 8
ORDER D - ITEM 4
My problem is trying to find out for example how many orders I have with items 4 and 8 in the same order and so on. An analysis of the mix of items on each order, I have tried everything here but I have not yet succeeded ... The problem too and that there would not always be the sequence of the same items ... In my head it would practically look like:
ITEM 4 AND ITEM 8 - 3 ORDERS
ITEM 1 AND ITEM 4 - 2 ORDERS
ITEM 4, ITEM 8 AND ITEM 1 - 1 ORDER
Forgive my English, I still haven't found a solution in BR.
Bookmarks