How can I display the latest date of payment in a Pivot Table?

I have a pivot table based on following columns; date, dealer name, particulars, qty., rate, debit, credit. I want to display the last date of payment and paid amount for aging of accounts