Filter by using a pivot table value

Dear all,

I need your help on creating a calculated field which gives me the sold quantity (the values are stored in Sold_Table) by applying the same filter in the pivot.

I think something like:
ROW C11 = Quantity having YEAR=B1 AND SPECIAL_PN=B2 AND CHANNEL=B3 AND SERVICE=A11 taken from Sold_Table
ROW C12 = Quantity having YEAR=B1 AND SPECIAL_PN=B2 AND CHANNEL=B3 AND SERVICE=A11 AND PRODUCT=A12 taken from Sold_Table
ROW C13 = Quantity having YEAR=B1 AND SPECIAL_PN=B2 AND CHANNEL=B3 AND SERVICE=A11 AND PRODUCT=A12 AND PN=A13 taken from Sold_Table
ROW C14 = Quantity having YEAR=B1 AND SPECIAL_PN=B2 AND CHANNEL=B3 AND SERVICE=A11 AND PRODUCT=A12 AND PN=A14 taken from Sold_Table
and so on...

Thanks