Hello everyone, 

I have two tables, one with the records of LEADS with a key of Channel/Month and another table with the TOTAL COSTS with one occurrence per key of Channel/Month. I basically need to create an aggregate formula that allows me to calculate the TOTAL COSTS per sum(LEADS) (basically divide one by another). The issue is that on the dashboard Zoho Analytics basically replicates the TOTAL COSTS for each LEAD, turning the formula useless.

Is there any way to create a SUM function that only sums based on each occurence of another column? 

Thank you,

JL