How do I create a Drupal View to display last activity date.
All right...I did it but just wanted to follow up.

Expand Advances in the View UI, click next to Aggregation on the word No.


Turn it on.

Now Add the Scheduled Activity Date field.



Click Apply, then the Aggregation options will pop up.

Select Maximum in the drop down list.



Then click Apply.

Here is part of my output (with other fields too of course).