To add more details to what @Chris_Conn explained,
Right click on your first query → Properties → Publish tab and select PartNum for your case.
And for your second query → Properties → Filter and select the published column from your first query.
To add more details to what @Chris_Conn explained,
Right click on your first query → Properties → Publish tab and select PartNum for your case.
And for your second query → Properties → Filter and select the published column from your first query.
