How to convert flat data into monthly - GL example
Confused on how to work with this flat data and derive monthly values from it. Appreciate the help!
Each row is a unique combo of Account (GBAID), Ledger Type (GBLT) and Year (GBFY). The snippet attached is 4 entries for the same account and ledger type for 4 different years. GBAN01-12 are entries by month. For example, GBAN11 for the row for 2018 would be the value in November 2018, the 2021 row only has values through GBAN05 aka May because we have not closed Junes books yet (today is June 23).
I want to be able to separate these entries by month in another module dimensionalized by time so I can track entries for any account combination over time. For example, a module could be dimensionalized by Account and Time/Months and each month's value would be a combination of its GBAN and GBFY in this dataset.
Thanks for your help.