Help to Arrange my Column section in this pivot

Dear Friends,

If you look at the pivot in the second tab in my spreadsheet,It shows what are the payments due on each days and its respective bank.

The problem here is,i cant understand how to show the loans from the oldest to newest,means dates of payment to be in order.

ALSO PIVOT REDESIGN SUGGESTIONS ARE WELCOME Book-wesite.xlsx

help my dear friends

Hi,
please look at the attached. It all depends on how you want the info displayed. I changed the pivot style to classic by right clicking in the pivot table and choosing the option as in the screen shot. senario 1 is by Date bank and total. senario 2 is by bank and due date. this is probably the better option as you can copy each pivot and display each bank like ive done in the 3rd tab. hope this is what you are looking for........Oh by copying the pivots you keep the size of the workbook down too , as it uses the same cach to store the info..

thanks mate.big cheers to you bro