### Combining Demand table with date table

Posted:

**Fri Oct 13, 2017 3:47 am**Hy everyone,

new to PowerPivot and a litte curious.

I have two tables and want to make a pivot out of the combined results.

The first table is a matrix with parts numbers as rows and order numbers as columns.

The actual demand is in the matrix. Like 4 pieces of part 333 in ordernumber 12.

The second table hast the order numbers from table 1 and the date of the orders.

Like ordernumber 12 is due in calendarweek 47.

Now I want to combine this data in a Pivottable.

So I can see how much demand for a part number is due in a specific calendar week.

The question is if Powerpivot is the right tool to look into in this case?

I attached a excel showing the case in detail.

demand per order is table1 as used above, order date is table 2 as used above.

Table aggregated demand shows how I try to have it.

Best greetings

Erdmensch

new to PowerPivot and a litte curious.

I have two tables and want to make a pivot out of the combined results.

The first table is a matrix with parts numbers as rows and order numbers as columns.

The actual demand is in the matrix. Like 4 pieces of part 333 in ordernumber 12.

The second table hast the order numbers from table 1 and the date of the orders.

Like ordernumber 12 is due in calendarweek 47.

Now I want to combine this data in a Pivottable.

So I can see how much demand for a part number is due in a specific calendar week.

The question is if Powerpivot is the right tool to look into in this case?

I attached a excel showing the case in detail.

demand per order is table1 as used above, order date is table 2 as used above.

Table aggregated demand shows how I try to have it.

Best greetings

Erdmensch