Sum Weeks to Months based on date of WeekMonday
I am desperately trying to map which weeks go into which months, based on the date of the monday. The monday should hence decide the month for which the given weeks data should be allocated in full.
Please see enclosed image (see "ISOWeekMondayMonths"), where I have managed to have the system automatically help me assign the right months to the given weeks. Problem is I am not sure how to reposition and utilize it to calculate the wished for monthtotals in the data/calculation-module (see "MonthTotals.png")
I want to avoid anything that relates to "Fake weeks, months" etc. and instead solve it through mapping or similar.
Found some previous posts that are somewhat close to this challenge, but I have not been able to solve it despite their helpful content - maybe a sharper Anaplanner can help me adjust the solution to the issue I am facing?
Thanks in advance )