Filter by using a pivot table value

[lucausa75]

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

[lucausa75]

Yes, this is excel and I wrote in this forum because in the past I have received help...

[HotChilli]

So many questions...

This is Excel , yes? Are you on the right forum?

If you want this in powerbi, it looks like you want a measure and there are 3 slicers .

Can you post sample pbix or data from the Sold_table?