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

  • @BrodieAlexander 

     

    Assuming you did the previous steps correctly; the module should look like this (naming apart):

     

    Screenshot 2022-10-11 at 14.42.32.png

    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 you