Different Dates based upon 2 different columns

The table below shows MQLs by latest date and latest event flag.  I would like to show the volume of MQLs that are Not Accepted or Achived using the MQLs - latest date.    So in my below example...