I would like to measure the % of repeat customers from the previous month in the current month.
The formula am using is ;
% Repeat Customers In Dec = ( # of customers ordered in Nov & Dec ) / ( Total # of customers Ordered in Nov )
I have attached a copy of the workbook.,
I believe your "repeat customer" is functionally equivalent to "retention rate," as described in detail in this video: Tableau Request Live - User Retention Rate on Vimeo. If you still have questions after that, reply here with the details of your issues, and we can see how we can help.