how to total columns rather than the row total

[Anonymous]

If the amounts  in a column are calculated  from other columns , how to you add the column rather than have it calculated by the totals fro other columns.

Example 

A	B	C	D	E	F	G
1	14,500.00	30.54%	4,428.93	7,250.00	-2,821.07
2	142,500.00	77.11%	109,885.77	99,120.00		10,765.77
3	2,006,505.00	62.64%	1,256,841.82	1,307,905.00	-51,063.18
4	301,905.99	90.00%	271,716.56	272,605.99	-889.43
5	135,449.66	2.21%	2,999.29	0.00		2,999.29
Total	2,600,860.65	62.01%	1,612,731.61	1,686,880.99	-74,149.38

Column D is 30.54% of Column B

Column  D Minus Column E, if Negative = F

Column  D Minus Column E, if Positive  = G

Note Issues with Total.

Need to Add Columns F  and G not Calculated Total of D Minus E

[oknotsen]

You can use the names of the columns in expressions or refer to them with the column() function.

So you could do....

column(6) + column(7)

Will that solve it for you?

If not, can you give a more clear example?

[Anonymous]

Could you please elaborate ??

Need to Add Columns F  and G not Calculated Total of D Minus E ?

You want  to add F and G columns ?

[swuehl · Accepted solution]

I guess you want to have sum-of-rows total mode instead expression total for the last to columns, right?

In a straight table chart, you can change the total mode on expression tab for each expression, change it to sum of rows.

In a pivot table chart, always 'expression total' total mode will be used.

But you can emulate a sum-of-rows total mode in a pivot table using advanced aggregation (there is a chapter in the HELP about this, too).

It may looke like

=Sum(Aggr( YourExpression, YourChartDimensionFieldsCommaSeparated))

in your example maybe like for column F

=Sum(Aggr( If(B*C-E<0, B*C-E), A))