I need some help with an “ActiveProductPath”, hopefully someone can help me.
I want for each customer the path of the active products, see attachment,
For example customer 1 has bought 4 products in 2019.
On 01-04-2019 was only product A active, on 01-07-2019 also product A, on 01-10-2019 the products B and C were active and on 01-01-2020 is product D active.
The endresult on 01-04-2019 should be:
Furthermore, the “path” for each customer contains unique products, so if a customer has bought multiple items of a product (for example 4 times product A), the endresult gives only one A.
Can someone help me?
Thanks in advance!
Greetings from The Netherlands,