Sum with conditional in Powerpivot

Hi everybody,

I have 2 Table below:

Table 1:

Product No Year Month Receiving Quantity
A 2015 6
B 2015 6
C 2015 6


Table 2:

Product No Receiving Quantity Year Month
A 100 2015 6
B 200 2015 6
C 100 2015 6
A 250 2015 6
B 300 2015 5
C 400 2015 5
A 250 2015 5
B 300 2015 5
C 400 2015 5


All I want is In column Receiving Quantiy in Table 1, it will show the Total Receiving Quantity in Table 2 which match Product No, Year and Month.

The result should be like this:

Product No Year Month Receiving Quantity
A 2015 6 350
B 2015 6 200
C 2015 6 100

I try a lot of formular but it does not work. Please help me in this case.

Thank you very much.



June 29th, 2015 3:40am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics