I have a table with fields that have Year and Month. Also holds an amount.
Looks like this:
Account------Year------Month------Amt
1234 --------2016--------12 ----------120.32
1234 --------2016-------12------------199.00
1234 --------2016-------11------------1998.00
I would like to sum the amount by Year and Month and have my columns be from the current date back 13 periods.
Is that possible?
Looks something like this:
Account------201612 ------- 201611 -------.........
1234-----------319.32----------1998.00