In a CrossTable, use a column name to calculate other column

[Sergio do Nascimento]

Hi all,

I have a cross table with many columns with complex custom expressions. I want to do a new column that is a calc between two columns.

Is there a way to refer a "column name" instead of repeat the expression

Example

Like this:

Sum([field1) as [A], Sum([field2] as , [A] / as [C]

Instead of this:

Sum([field1) as [A], Sum([field2] as ,Sum([field1) / Sum([field2] as [C]

 

Regards

[Sergio do Nascimento]

I used documentproperties to do that, but in some cases the expressions are too big to save as a string property...

Property A = Sum([field1)

Property B = Sum([field2)

CrossTable expression:

${A},${B},${A} / ${B}

Is there other way to do that