Hi I need to calculate, SUM of a new and lostcustomer sales past two years. Lost= made sales last year, but not the selected year New= sales made selected year but not last year
Hi! I'm struggling to find a solution to count new/lost/returning/loyal customer over the years... I've tried different approaches posted on the community (script and expression), but couldn't r...
Hi All, I want to find total inactive customers for last 12 months on month basis which means they have placed order before 12 months back and became in active. So want calculate this every month b...
Good morning, I need a little help finding current, new and lostcustomers. The first part of the script finding old customer and newcustomers seems to work, but the lostcustomers I am h...
Hi All, I am trying to find Lost, New and Loyal customers month wise. User will select year and a month, a pivot table should show the count of the customerslost in current month, newcustomers...
I have the following logic to calculate LostCustomer - hasn't bought anything the last two years NewCustomer - bought something this year, but nothing the last two years Total Customers - e...
Hello everybody! Is there an elegant way to state how many customers we have gained in a given year compared to the previour year? In the attached example Tom is a loyal customer, Jim is a new one a...
...egarding lostcustomers and set analysis, and I have to saythat for a newbie the SET Analysis is very complicated. After several days, I have prepared the following expressions that give me a very g...
Hi, I have a query where I need to find out new and lostcustomers monthly. New - A customer which did not have a record in last month sales data. Lost - A customer which had a record in l...