Forum Discussion

DanielBrown's avatar
DanielBrown
Qrew Trainee
9 years ago

Show Last Item from Many Relationship in Report

We are creating a sales pipeline type tool where one Opportunity has many Activities.  On the main report for the Opportunities, I show the # of Activities for a given opportunity.  I've figured out how to show the date of the last modified Activity using a Date / Time (summary) field set to Maximum.  However, I can't figure out how to show the Activity Name for the last modified.  Given this data:

Date Modified | Activity Name
3/1/2017 | Opportunity Received
3/3/2017 | Contacted Client
3/8/2017 | Contract Sent

I can display "3/8/2017", but I want "Contract Sent" displayed in Opportunities Report as the last Activity for the given Opportunity.  Is there a way to do that?