Good Afternoon. I hope all is well.
I am using Cystal 2008.
How do i bring back all transaction details which include product code: 5001, 5005, 5010, 5015
for example
transaction 1
5001 (kit kat)
5503 (mars bar)
transaction 2
5005 (m&m)
5001 (kit kat)
2015 (coff8e)
So all transactions that do not include any of the listed products I will need to exclude.
However i need to see all parts of the transaction where 1 or more items from my list above are present.
I hope that makes sense.
Many Thanks
Dannyb
I am using Cystal 2008.
How do i bring back all transaction details which include product code: 5001, 5005, 5010, 5015
for example
transaction 1
5001 (kit kat)
5503 (mars bar)
transaction 2
5005 (m&m)
5001 (kit kat)
2015 (coff8e)
So all transactions that do not include any of the listed products I will need to exclude.
However i need to see all parts of the transaction where 1 or more items from my list above are present.
I hope that makes sense.
Many Thanks
Dannyb