Summarize table before calculating Percentile

I have a table of received POs that consist of a Supplier, date of PO, Qty that was received On Time, and Qty Recieved Overall.    Supplier Date OnTimeQty OverallQty A 2/2/2023 4 10 ...