Product introduction analysis

Hi all,
I’m stuck with what I thought would have been easy.
I’m trying to find out which year/month a product was sold the first time out of a transaction log based on Year and Month (no date).

My thought was to create a pivot on the product where pivoted columns are Year-Month and detect when I have a first sales.
But I cannot find a way to do the latter.

Can anyone help?
Thanks a lot,
Raoul.

@Raoul_tS you could try and make an integer out of the date with yyyymm and then use the group by node?

2 Likes

Thank you for the reply.
That was the good idea, just using a minimum on the period. :slight_smile:

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.