ok. i figured it out. CTE was a dead end (i think, i had an epiphany half way through it and bailed)
it appears you cannot use two separate pivot tables in one query (far far FAR be it from me to verify or explain…lol)
however, you CAN pivot the same table multiple times (at least twice that i know of anyway)
so by adding a second pivot of the same subquery and adding a criteria for only complete operations, i am able to count how many of op1 there are for all jobs linked to an order and how many are complete. Thus, catapulting me forward to whatever my NEXT dilemma ends up being.
probably just telling everyone what they already know, but i find it irritating when forum topics end with “figured it out, thanks.” it’d be a shame if i were “that guy”
thanks again for the help!!!