Design Help - Activity on Account Level
We currently use a report which shows all contacts by account with their last activity and the VP(s) who were linked to this activity. The problem is that this is at the contact level - the issue I'm trying to solve is this:
Because the activity is at the contact level, it is pulling the same contact into multiple accounts. For example, Contact A currently works at Pfizer. He has not had any activity with this company. His past job was with Genentech. He did have activity with this company. The report will pull this same contact into both accounts and list the Genentech activity with both Genentech and Pfizer.
Because the activity is at the contact level, it is pulling the same contact into multiple accounts. For example, Contact A currently works at Pfizer. He has not had any activity with this company. His past job was with Genentech. He did have activity with this company. The report will pull this same contact into both accounts and list the Genentech activity with both Genentech and Pfizer.
0