Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Quarterly Sales vs Quarterly Target based on Country

Hi,   I am trying to get the Quarterly Sales divide by Quarterly Targets for each country, I cant figure out how to do the data modeling and get the result. I can get the quarterly sales, however d...
Need Help
  • shebr's avatar
    shebr
    8 years ago

    HI Anonymous

     

    What you may need to do is create a new column  that concatenates the country and quarter, and do the same for the 'actual' table also and then join the table on this column.

     

    Thanks

     

    shebr

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi,

 

I did tried but i am stuck when I have to match it with current quarter my target table looks like below :

 

   
shebr's avatar
shebr
Icon for Resolver III rankResolver III
8 years ago

HI Anonymous

 

What you may need to do is create a new column  that concatenates the country and quarter, and do the same for the 'actual' table also and then join the table on this column.

 

Thanks

 

shebr

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi shebr Floriankx

     

    Thank you very much for all your help, It worked for me like a charm :)