Hi Joshua, I think you're nearly there actually! The key thing to realise is that SUM is not going to work on General Weeks, as there is no recognised hierarchy. It just returns zeroes (as you've demonstrated). However, if your formula adds Week 1 + Week 2 + Week 3 + Week 4 for each month then it will work. You might need to flip your mapping table round so you have the Week 1 to Week 4 list and L2 Months as dimensions, with a line item for the General Week that is formatted on the timescale, and relates to the appropriate intersection (eg the data point for Week 1 of Jul-19 is 'W/c 1 Jul 19' or whatever the start date of your first week is). Just remember you need to copy the formula 4 times, changing the week number (1-4) and leaving everything else the same, and add them all together, to give you the summation. As I mentioned in my initial post, there's probably a better way to do it, but I know it will work this way At least you've only got a maximum of 4 weeks in each of your months, look on the bright side 🙂 Let me know how you go Steve
... View more
