Forum Discussion

OSS's avatar
OSS
Icon for Helper III rankHelper III
7 years ago
Solved

Multiply two tables

Dear all I have two tables. First table contains account numbers and amount columns. The second table also contains account numbers and division percentages.   I need to connect these tables via ...
Need Help
  • OSS's avatar
    OSS
    7 years ago

    How I have solved the problem:

     

    First I have unpivoted the second table with percentages. Then muptiply with the previous table.

     

     

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi OSS,

 

Could you please mark the proper answers as solutions?

 

Best Regards,

OSS's avatar
OSS
Icon for Helper III rankHelper III
7 years ago

How I have solved the problem:

 

First I have unpivoted the second table with percentages. Then muptiply with the previous table.