Hi Guys, I hope you are well.
I am trying to create my own groups within Crystal based on a set of sales trasactions. My aim is to count the occurances my employee sells a promotion. For example:
If a customer buys 1 or more kit kat and 1 or more salt and vinegar crisps, i need to count that transaction and then call it KitKat Promotion.
If a customer purchases 1 or more mars and 1 or more twix then i need to count that transaction and call it Mars Promo. Both products have to be within the same transaction ID in order for it to count as a promotion
This is how i will need the report to look.
Kitkat Promo Mars Promo Malteeser Promo
Lisa Hansel 1 3 5
Dan Tring 0 8 1
Rich Staines 2 1 10
I hope this makes sense
Many Thanks
Dannyb
I am trying to create my own groups within Crystal based on a set of sales trasactions. My aim is to count the occurances my employee sells a promotion. For example:
If a customer buys 1 or more kit kat and 1 or more salt and vinegar crisps, i need to count that transaction and then call it KitKat Promotion.
If a customer purchases 1 or more mars and 1 or more twix then i need to count that transaction and call it Mars Promo. Both products have to be within the same transaction ID in order for it to count as a promotion
This is how i will need the report to look.
Kitkat Promo Mars Promo Malteeser Promo
Lisa Hansel 1 3 5
Dan Tring 0 8 1
Rich Staines 2 1 10
I hope this makes sense
Many Thanks
Dannyb