I have made a pivot of the attached but I cant seem to manipulate it the way I want.
The raw data is organized as DD Amount ("draw down amount"), DD Date, Repay Amount, Repay Date, Payment Made Yes or No,
The grouping of data isnt that great when I put into a pivot table and I am not too familiar with pivot tables.
If I could put the Repayment Date in the "Sum of Value" I think it would look better however excel "counts" the field instead of showing the field as a date. I also need to show the Payment Made field in the sum values part but I have the same problem as excel counts the field.
Possibly an expert could organize the data a bit better than I can.
Please see attached file.
Grateful for your help