Refer to columns in other charts

[#1]

Hi folks,

Is it possible, when writing an expression for a chart field, to refer to columns in other charts?

I have three existing charts, each of which produce a column which is summed to produce a total. Each of these three charts were calculated using different date ranges.

Now, I would like to create a fourth table which takes the 'total' fields from each of the other three charts and sums them to produce an overall total.

Is this possible?

Thanks,

Cillian

[#2]

Hi,

You can add the columns at your new chart en hide them.

So you can use them in de expressions.

Halmar

[#3]

sorry, i forgot something.

You can use total in your expression to use the totals.

But I prefered to make a new expression to get those totals.

Halmar

[its_anandrjs]

Hi.

I suggest you can use

Sum( All Total YourField )

You can use eithere All or Total

Rgds

Anand

[#5]

Thanks for the response Halmar.

Unfortunately when I try your suggestion I run into problems. I'm trying to display all three total columns from the original three charts alongside a Calendar.Day column in a new chart.

One of the totals in the original three tables is a simple expression which works fine when imported to the new chart. But the other two totals contain conditional 'if' statements. When I attempt to display these in the new chart, the columns are blank.

Any clue what I might be doing wrong?

Thanks