In the "Report" file, I loaded two tables from the "One" file and the "Two" file. Next, in Power Pivot, I want to multiply the "Quantity" column of the table from the second file by the "Sum" column from the table of the first file. Then an error. Why?
Because you didn't define which field from table "One" should be included in the sum.
But your question can be interpreted in multiple ways.
Could you provide a sample set of data from table "One" and table"Two" and describe in more details what you're trying to accomplish.
Check the FAQ and rules of the forum, listed here. More specific how to provide sample data etc. which is listed here
Also look at the guidelines and Rules which are linked in my signature
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
