Jump to content
We've recently updated our Privacy Statement, available here. ×

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


Sergio do Nascimento

Recommended Posts

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

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...