Weekly subtotals for model with calendar type M/Q/Y
Do you know any elegant solution for entering weekly subtotals or week ID's into module of model with calendar type month/quarter/year?
Cause I faced such issue:
FP&A team wants a module for calculating daily sales plan - that's ok, but another step of the process is review of that plan by BU owners who make adjustments as a weekly effects which i need to allocate on a daily plan. And due to my model has a calendar type month/quarter/year it's not an option to change it to the weekly type...