I have a piece of data which is based on unique keys. Each key has data for multiple months. Also there is another column which specifies the financial year. I have created an intermediate module where each transaction for a key is flattened out by month. So i have line items which derive the month value in text ('01',02',12' etc in 'mm')and year value ('15','16' etc in 'yy')in text format for each transaction.
I want to be able to create another line item from the month and year which combines them together so that it creates a period in mmyy format which i can then use sum the line items together by the financial period. For example all 0116 should sum under Jan 2016 time dimension 0218 should sum under Feb 2018 time dimension. Will i need to create any list for month year? how do i go about this?
Solved! Go to Solution.
I use one of the following two options, neither involve a list:
If you are starting with data that looks like this: ('01',02',12' etc in 'mm')and year value ('15','16' etc in 'yy')
Then some of the statements might look like: