Forum Discussion

OSS's avatar
OSS
Helper 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
Microsoft Employee
7 years ago

Hi OSS,

 

Could you please mark the proper answers as solutions?

 

Best Regards,

  • OSS's avatar
    OSS
    Helper 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.