Hello,
I am tryng to find out how can i generate a report or query that will allow me to see the targets with the most target lists?
I use different real estate lists, and i created a target list for each category.
- Absentee
- Vacant
- Tax Delinquent
- Foreclosure
etc…
I want to print a list of records with the most occurences of lists
.
John doe - 4
Mary joe - 3
Peter doe - 2
and possibly be able to see what list is each target on like
John Doe - absentee/vacant/tax delinquent/foreclosure
mary doe - absentee/vacant/foreclosure
peter doe - vacant/foreclosure
etc…
I tried to create a report in targets & in targetlist, with the ids and conditions matching vacant & foreclosure but i get 0 hits, when peter doe is on both list… it works when i try the report only on 1 list…
Anyone help on i can do this?
thank you