Dear Alteryx experts,
I am trying to add a new column to indicate the sequence of purchases for each customer. I have tried tools like Running Total and General Rows, but it doesn't work for me. I have also tried the Multi-Row Formula tool, but it doesn't seem to work for my case. Does anyone know the solution? Thanks!
Herman
Solved! Go to Solution.
Hi cheunghm4532
I have used the Multi-Row formula to get the answer to your question.
IF ([Row-1:Customer]!=[Customer] AND [Row-1:Transaction Date] != [Transaction Date]) THEN 1 ELSE (IF [Row-1:Transaction Date]=[Transaction Date] THEN [Row-1:Count] else [Row-1:Count]+1 ENDIF ) ENDIF
Hi Kaviyarasan,
Thanks! You are my hero!
Herman