Summation using Months and Year

Options
subodhp
subodhp Member, ALL USERS, Community Member Posts: 5 Occasional Contributor
in Planning & Modeling

Hi All

 

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?

 

Thanks

 

 

Tagged:

Categories