Returning the sequence of customer purchases for each customer

Question

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

Kaviyarasan_P · Accepted Answer

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