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

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 :)