Need to use the transformed column in another Table

[Ramu]

Hey,

I have a manually created Table T1 transformed using Table Transformer to display the 'Name, Salary, Bonus, Total'   ->  out of which the Total Column is defined in Transform logic as :

(T1.Salary + T1.Bonus) as 'Total'

now, i have another Table T2 (Transformed) where i want/need to refer/use this 'Total' column of first Table transformed.

for ex,

my T2 has columns like ' Name, Availability, Billing' ->

here for the 'Billing' column's calculation, i want to use the 'Total' column of first Table ..

we are aware that this cant be done as T1.Total (coz "Total' was a transformed/defined column and not originally the built in column of T1 ..)

So, how to refer the T1's Total column in my T2 calculation/Table ?

i.e., How to call/use the Transformed COLUMN in one Table into the other Table ?

Please help  ..

@Stiltsoft Support

[Stiltsoft support]

Seems to be a duplicate of this question https://community.atlassian.com/t5/App-Central-questions/How-to-use-the-transformed-column-in-another-Table/qaq-p/2729915#U2730686