Weekly subtotals for model with calendar type M/Q/Y


Hi, colleagues!
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...

Best Answer

  • Misbah
    Answer ✓



    If the timescale is already selected as Months then I would say create a dummy weeks list into your model and create a relationship between Anaplan time and Custom time of weeks.



    Miz Logix