In case anyone has the same need here is what I did.
In the report I opened the Reports properties dialog and selected the Code tab. Then I inserted the following code: (Note first revision so may go back and sharpen a bit later)
Function SetValue(valID, valAmt)
If IsArray(arX) Then
x = UBound(arX,2) + 1
ReDim Preserve arX(1, x)
arX(0, x) = valID
arX(1, x) = valAmt
For x = 0 to UBound(arX,2)
If arX(0,x) = valID Then
GetValue = arX(1,x)
From there in Table 2 when I am outputing the column A value I do like so.
Expression: =Fields!A.Value & Code.SetValue( Fields!Col_ID.Value , Fields!B.Value)
Which allows me to store the data I need (note: before you answer I should have joined or anything Table 2's data is not matching what I have, what I needed was to get the calculated value of serveral columns and to build the data for Table 2 takes 351 Lines of query which I don't want to have to run again for table 8).
Then in Table 8 I do the following
=(Fields!V1st.Value + Fields!V2nd.Value + Fields!V3rd.Value) / (Code.GetValue( Fields!Col_ID.Value))
Which allows me to retrieve the stored value and bring into my calculation for the "% Performed In Escalation" column in that table.