| I am trying get number of customers who brought sample product and them later on dat brought standard product. |
| they have item relation id as it says they belong to same family but different product type. |
| consedering date of the order where standard product is purchased and checking back if they ever brought sample from same family which is based on item relation ID ID. |
| I have created monthyear field based on order dates so trying to get analysis month wise . |
| Thank you . |
| Below is the example. |
| Date | Customer | Order number | Item No_ | Product Cat | Description |
| | | | | | |
| 10/02/2017 | 1028245 | 24166068 | 6766 | Sample | Boss The Scent For Her Eau De Sample |
| 06/03/2018 | 1028245 | 30676250 | 6768 | Standard | Boss The Scent For Her Eau de Parfum 30ml |
| Item relation id | Item No_ | Product Cat | Description |
| 1 | 6766 | Sample | Boss The Scent For Her Eau De Sample |
| 1 | 6768 | Standard | Boss The Scent For Her Eau de Parfum 30ml |
