Is the following possible within pivot or power pivot?

Hello 2dA4d8Pm and Welcome to Excel Forum.
As this has been sitting here for a while with no response I thought that I would offer a formula based proposal.
For Example 1 the the following seems to work:

Formula:

Please Login or Register  to view this content.

Note that I made some changes to the other sheets in the workbook.
If this is acceptable then we can work on the Example 2 formula.
Let us know if you have any questions.

I believe that I missed the way cell H7 was calculated and that the following placed in cell F7 and then copied over and down yields the correct values:

Formula:

Please Login or Register  to view this content.

Let us know if you have any questions.

Not making a promise however there might be a possibility of using power pivot if the setup of the data was rearranged. Would that be acceptable?

This gets pretty involved, however here is a brief overview:
1. Make connections of the Product Mix, SKU Table and Store Velocity tables.
Note that in the SKU Table connection only the SKU and Gross Profit columns are used in the connection.
Note that in the SKU Table connection the Wal Mart and Target columns are unpivoted.
Note that to see the connections you may need to select the Data tab and then select Queries & Connections.
2. Merged the Product Mix and SKU Table connections
3. Merged the above connection with the Store Velocity connection
4. Made a connection of the Store Mix table
Note that the Wal Mart and Target columns are unpivoted.
5. Merged the connection tables from steps #3 and #4 and added a multiplication column
Note the table produced in step #5 is on the Table for Output sheet
The pivot tables for gross profit per Sku per month and Gross profit per channel per month are on those respective sheets.
Let us know if you have any questions.