Hi All!
I am trying to solve the following problem in Alteryx: I need to be able to flag when a certain product started selling. Let´s say I have data from 2022 till 2024 for different Customers and Different Products. I need to identify which customer started selling a certain product. For each customer and each product I always will have records for each month in 2022 till 2024 November. Each record represents 1 month.
Now as I want to understand the time period before and after the product was introduced I need to be able to have a month 0 (the month the first time we see sales (can be found in column Amount) and the record of this same product for this same customer before month 0 need to -1,-2,-3 meaning 1 month before month 0, 2 months before month 0 and so on. The same needs to happen in the other direction: after month 0 I will need to have month 0,1,2,3,4,5,6 and so on.
I attached the excel file with the data and in the column example you see what I did manually in excel. I have been trying to use the Multi Row Formula but as it I believe reads from top to bottom I fail to understand how I can configure the -1,-2,-3,-4.
The reason I need it is because I want to be able to analyze the sales months before and after the introduction and the points can start on different months.
Hope anyone can help me! (I haven´t shared the Alteryx WF as I only have a multi row formula that doesn´t do anything yet that is remotely correct).
