Help creating a weekly variable from a monthly dimension.
I have a straight table with Forecast by Country by Month (2011). I need to create a table that gives Forecast by Country by Week. For purposes of this request, I can assume that the numbers of weeks in each month equals the number of Saturdays in each month. Then I can take the Forecast for each month and divide by the number of Saturdays in each month to get a "rough" Foreacst by Week.
I can’t quite come up with the best approach/formula/expression/etc. Does anyone have any suggestions?
