L3 TAR01 Module

Hi, 

 

My TAR01 Detailed Sales Target is off. I'm not sure why. I tried to pull from D02 Data Module, but then my dimensions were wrong and wouldn't let me look up by product and country. I have been stuck on this one for a while. Please advise. 

 

Thank you 

neg177_0-1664913514876.pngneg177_1-1664913547763.png

 

Comments

  • Hi @neg177 

     

    I can't help but notice that your 'PY Country and Product Family Sales' all have the same amount. It also show that your module is using a Qtr dimension. I assume that your source module is spread in a monthly view? With all the information there are still many possibilities, but I think your data need a LOOKUP or SELECT, which will differentiate the amount per item.

     

    Hope that helps

  • ok, Thank you