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
+13- 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,
Log into the Pigment Community
No account yet? Create an account
Single Sign-On Need help?
Log in with your Pigment accountEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.