Add Most-Recent Open Activity Column and Most-Recent Closed Activity Column in Report

Add Most-Recent Open Activity Column and Most-Recent Closed Activity Column in Report

In a Potentials Report that includes Account/Contact/Activity modules in the report, I'd like to display two columns: one that shows the most recent open activity, and the most-recent closed activity. That way I can make a report that shows what the next open activity is, and the most recent closed activity.

Is this possible to do?