I think you're very close but we need to go back to my original response. I'd recommend you reload PY Sales Import. Your numbers are slightly lower suggesting you missed some data. When you load there should be no errors. Here's the summary of PY Sales:
Re: Level 3 calculate the Quaterly Initial Sales Target
@JaredDolich - I am actually stuck in the same thing and need your help.
1. In the Level 3 Sales Planning Model I have created a module and successfully imported the data from the data hub for Actual Sales Revenue. Its dimension include - A1 Accounts, P2 Products
2. I have another module in which I have dimension as G2 Country, P2 Product Family, A2 Account>Product#
I am not able to do a lookup from the earlier module and using the SYS03 Account>Product Details. It says level mismatch on common dimension.
I am just stuck here please can you help me how to move forward after importing the data from the data hub - I understand I will have to use LOOKUP and SUM and I have used those formulas earlier - In this particular scenario I am not able to understand how to use them.