Forum Discussion

abc_777's avatar
abc_777
Solution Specialist
3 years ago

hi

Hi,

 

I have a product list with invoice list. cusotmer purchase various product. i want to find the product combination with number.

 

I give an example as follows

 

invoice number product barcode customer purchase as invoice number
123 p111
  p222
  p333
   
   
234 p111
  p333
  p222
  p555
   
345 p333
  p444
   
   
456  
  p222
  p111
  p444

here the number of product combination that customer purchased

 

p111 p222=3 p333=2 p444=1 p555=1
p111=3 p222 p333=2 p444=1 p555=1
p111=2 p222=2 p333 p444=1 p555=1
p111=1 p222=1 p333=1 p444 p555=0
p111=1 p222=1 p333=1 p444=0 p555
No RepliesBe the first to reply