for the purpose of data sharing use binary function which reload all data of 1qvw file into another
and in concern of adding column use inline function for define that column virtually not actul
and for last using pivot table and write the expression
sum(distinct debt )/sum(total <year>debt).
hope it helps you..for last query i didnot get you exactly..