Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys
I’ve created a pivot that shows total leads, distinct leads and sales. My dimensions are AgentName and LeadSource, and my expressions are count(distinct leads), count (total leads) and count sales. Now when the pivot is expanded, the individual count of sales does not add up to the total. It looks like I have more sales per lead source and that’s not the case. Count(Distinct Sales) doesn’t seem to help
Best I have is the following Help link that might help with this if what is going on are duplicate rows where things are getting dropped:
You could also use RowNo or RecNo functions in the load script to make each row unique that way as well, but the above is likely a good thing to try first to see if that might do the trick for you. If that does not work, then look into RowNo and RecNo:
Regards,
Brett
too vague unfortunatly. can you share some screenshots. and some example of how the data looks like etc.
Hi
I have attached the collapsed and expanded pivot.
Data is from 2 tables, one being SALES and the other LEADS.
Both tables have SalesPerson and Mobile as common fields, but the association here is made on Mobile.
Best I have is the following Help link that might help with this if what is going on are duplicate rows where things are getting dropped:
You could also use RowNo or RecNo functions in the load script to make each row unique that way as well, but the above is likely a good thing to try first to see if that might do the trick for you. If that does not work, then look into RowNo and RecNo:
Regards,
Brett