Activity Report - Last Activity
What they unltimately want is a list of their accounts showing the last single activity, and all future activities.
I wasn't sure if I could do this easily with one simple report, so I went down the path of creating two reports that I would merge together. However, I'm having difficulty just getting the report with the last activity.
For simplisity sake, lets say my reoprt consists of ACCOUNT, ACTIVITY DUE DATE, and ACTIVITY TYPE. I started with this list, and put a filter to only see accounts less that CURRENT_DATE. But not sure of how to see just 1 for each account. I started with TOPN, but that only showed me 1 row for the entire reoprt, not 1 row per account. MAX worked a bit better, but it would give me two different lines per account if there were two different ACTIVITY TYPES.