You have brought up a pivot report but it defeaults to count for all columns.
Can you change all to max with one operation?

Thanks