I’d like to use this previous example as a foundation for this question.
What if the value being rolled up isn’t a number/date, but a status?
We are an agency business who has a number of clients, each with their own product(s) that we are presenting to other organizations. We log our outreach to these organizations on one table, and each log entry contains a date, a status (Potential, Pending, Ongoing, On Hold, Lead, and Not Relevant), and some text on the action taken in that record.
Right now I have no problem sorting the entries on that table so that they are grouped by Org, then bu product, and the logs are sorted by date so most recent is first. I would like to, however, be able to pull up (for example, on the table that lists all the organisations we pitch to, see at a glance the most recent activity related to that product, with a particular organisation…
For example, Product A has ongoing conversations at 3 Organzations with multiple activity logs at each… For the sake of this example, if nn Monday, I speak again with Org1, Tuesday Org2, and Wednesday Org3… then on Thursday, I want to produce a report of the most recent activities related to Product A on the product table, I don’t want it to show me just the activity from Wednesday. I want it to display the activity from at Org1, Org2, and Org3… as individual pills or items that I can expand.
I can’t figure out how to do that.
Does anyone have any advice?
