Hello all,
Looking for some suggestions on how to get started with this problem,
I have a table with 65k records in it. It’s a ledger detail with account numbers and total amounts. For example, 500611 will have 12 entries, a total for January, then February (which will include January) etc.
My goal is to isolate the expense that occurred during each month. So if in January the total was $100, and in February the total was $150, I want to be able to distinguish January having $100, and February having $50.
I want to ultimately be able to create a standard table with the account numbers down the left side, and the 12 months across the top, and the values filled in.
My thought is to make a composite key, something like 500611_January then in the February column say February = 500611_February – 500611_January. But this seem like a lot of room for error,
Any suggestions?
Bookmarks