If you don't have to do any summary calculations, this is actually fairly easy.
1. If you haven't already, group by client.
2. Sort descending on the field that contains the date for "P1".
3. Put the data in the client group header and suppress the details section.
This will show the most current "P1" record for each client.
-Dell