Forum Discussion

acstaffa's avatar
acstaffa
Frequent Visitor
9 years ago
Solved

join information from different tables

I need to produce a report that divide sales per labor day. I created a table wiht the information of the labor days quantity by month, but a I cant make the calculation.

I tried to join the amount of labor day in a new column in the sales table, but I couldnt find a relationship to bring it into.

any ideas?

Need Help
  • acstaffa's avatar
    acstaffa
    9 years ago

    Hi, everyone. I solved it with the Lookupvalue and brought the information from on table into the other...
    thaks

  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi acstaffa,

     

    Great to hear the problem got resolved! Could you accept your helpful reply as solution to help others who may also have the similar issue easily find the answer and close this thread?:smileyhappy:

     

    Regards

4 Replies

  • acstaffa's avatar
    acstaffa
    Frequent Visitor
    9 years ago

    Hi, everyone. I solved it with the Lookupvalue and brought the information from on table into the other...
    thaks

    • v-ljerr-msft's avatar
      v-ljerr-msft
      Microsoft Employee
      9 years ago

      Hi acstaffa,

       

      Great to hear the problem got resolved! Could you accept your helpful reply as solution to help others who may also have the similar issue easily find the answer and close this thread?:smileyhappy:

       

      Regards

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Microsoft Employee
    9 years ago

    Hi acstaffa,

     

    Could you post your table structures with some sample data and your expected result? So that we can better assist on this issue.:smileyhappy:

     

    Regards