Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
You can add the columns at your new chart en hide them.
So you can use them in de expressions.
Halmar
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
Hi.
I suggest you can use
Sum( All Total YourField )
You can use eithere All or Total
Rgds
Anand
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