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

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 [B], [A] / [B] as [C]

Instead of this:

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

 

Regards

(1) Answer

Login