Calculated Column or Table?

[Yrstruly2021]

I have the data output in my tables for Sales Value and Sales Volume. To get Sales Volume share and Sales value share. I need to do a manually copy and paste and calculation to get the output, two reports at bottom please?

see https://drive.google.com/file/d/1lIXHGQWVv4N-OqFdD1o3V99XQOcp6TJ1/view?usp=sharing 

The following is the data output that i currently have, see: https://drive.google.com/file/d/1vzZP7crsCAGsXgzrJ7TJBrJsGwGPrjNR/view?usp=sharing

How do i outomate the process in powerbi, using dax or any other relevant functions to get the desired output?

@amitchandak @lbendlin @PhilipTreacy

[amitchandak]

@Yrstruly2021 , No access to files. I applied for. Also, the problem is not very clear.

Please refer to these two videos to move data from one table to another, if that can help

https://www.youtube.com/watch?v=czNHt7UXIe8

https://www.youtube.com/watch?v=Wu1mWxR23jU