Need the split of a week which overlapped two months into 2 partial-weeks. The target is to have a full calendar view of month and weeks together. The costumer can make planning on month or alternatively on week level, where data will consistently splited or aggregated. Moreover it is also important for aggregating the partial-weeks actuals to months in the correct way. e.g. week 18 in 2013 overlapped April and May. Costumer has to load data for week-18.April separately from week-18.May. In the same way they have to make his forecasting.
Solved! Go to Solution.
Please check the following screenshot:
Note : Refer SA model
Let me know, if this helps or not
Thanks Pavan, I just completed building this by using weightage method.
I have two questions for you, the start dates and end dates which is displayed on your picture is that manually put in?
And by your methodology of bringing in the days, how do you plan on using this to move data from module containing Anaplan time dimension and to the module which has this custom time dimension?
1) They are manulally mapped
2) While writing a formula, we should divide "No of days" by 7 for the value we are taking. (Its again like, giving weights)