Tableau is pulling in our customer purchase history which includes User_ID, Purchase_Date, Purchase_ID. Right now I have calculated fields set up to report on the number of unique buyers on a week by week basis. Looks something like the table below.
Now I want to fill out column 3, which is a count of the users that bought something in WeekEnding=X, but also bought something at some point in the past, excluding Week X, Ie they are a returning buyer.
Unique Buyer Count
Returning Buyer Count
Appreciate any insights on how to perform this calculation within Tableau.