Skip to main content

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 
 

Hi ​@Cedric LJ ,

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,

 

 

Reply


Ask your question here!

Terms & ConditionsCookie settings