Move data from fake time period to real time period (For restriction of drop down selection on time)
I want to move the data from fake week to real week. I tried with multiple formulae and still getting errors. Request your help.
Please find the screen shot of requirement below:
And I have a mapping module as below:
And my fake week list is as below:
Note: The reason why I have created a fake time is period is that my original time period has more than ~250 weeks including the historic years. But I want to select only from the 52 weeks of current year. So, I have created a fake time list and using a subset of 52 weeks alone from that fake time period as a selection drop down rather than the original ~250 weeks.