Level 3 Sprint 1 5.2 - Initial Account Sales Target (3.1.5.2)
Hi, I've been stuck on this task for some time and I don't understand what we are meant to do with Initial Account Sales Target Line Item do we use the same percentage Increases from the Data Hub model used for the Initial Country Sales Target Line Item.
I'm a bit clueless and would really appreciate any guidance I've attached what i have so far and I think the rest is correct, thanks in advance.
Comments
-
Assuming you did the previous steps correctly; the module should look like this (naming apart):
There are screenshots in level 3 to check your numbers.
Consider the formulas for the line items here:
- where the data is coming from
- appropriate use of SUMs and LOOKUPs
Ultimately the initial sales targets will be : 'PY Account / PY Country Product Family' * Initial Country Sales Target
But you need to carefully explore each line item formula to confirm.Level 3 is much more demanding than level 2 and requires more intense resolutions.
Thank you2