Calculate a grand total from 5 other totals

[Anonymous]

I have 5 total expressions. I like to sum those 5 total expressions into 1 grand total. How can I do this? thanks.

[#2]

Hi Hsm,

Correct me if i did n't got your problrm in a right way

but can try to use a pivot table and in the presentation tab of pivot properties select Partial sum which gives you a grand total of all of your total's .

thanks a lot

Bradd

[#3]

Hi Hsm,

You can try the grand total of five expression in this way also

Try to label your 1st expression as Sum1 2nd as Sum2 .....5th as Sum5.

and now write a new expression as Sum _Total=Sum(Sum1+Sum2+...+Sum5);

now you have a expression of grand total of 5 sum's  you can use it

thanks a lot

Bradd

[Anonymous]

Hi,

It does not work for me for some reason.

I am in the Chart Properites/Expressions. I label the first sum as IP, the second sum as OP. I only did 2 as a test.

I added a total sum. the label is total sum. The definition is =sum(ip + op)

Total mode is expression total

I do not know what I am doing wrong.

Thanks.

[#5]

Hi try this:

[IP] + [OP]

Regards

[Anonymous]

I am sorry but this does not work either. The IP and OP are in red. I am not doing something right for the. Thanks.

[#7]

Hi,

[IP] and [OP] should be the lables of your expressions, so you can use the expression [IP]+[OP]

Regards!