Hello,
I Have the below list of leads and I want to count 1 in the column Count only for the lastest lead of the company.
The goal is to remove duplicate leads of my lead analysis.
Thanks
+12- Employee
Hi
You can do this by using the CUMULATE function. I’ve made an example in the screenshot below.
You cumulate the number 1, across the Leads dimension and reset the value each time the name changes. The highest number will be the latest lead (e.g. nr 2 for lead A in my example).
You can remove the -1 at the end of the formula if you don’t want to see only duplicates (now unique items will be 0).
Hope this helps,
Kind Regards, Stef
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.