Hello,
I have a table that looks like this:
Account_Number----------Currency-----------PostingDate--------Closing Balance
1234-------------------------USD--------------July 1, 2016----------$100
1234-------------------------USD--------------July 3, 2016----------$100...