Sum of each column to be printed in last row
Posted: Tue Nov 04, 2008 3:07 am
Hi,
I want to print sum of some of the columns as the last row whcih shows the total of all the data coming in a particular column.
for eg
LA Vol1 Date Vol2 Vol3 Status
A 10 23/Feb/2008 5 10 F
B 20 23/Feb/2008 5 10 F
C 10 23/Feb/2008 5 10 P
D 30 23/Feb/2008 5 10 P
4 70 20 50
The last row gives the total of col data except for date column and status column. the data is like
4 is sum of count of LA
70 is sum of Vol1
Below date col it will be null
20 is sum of Vol2
50 is sum of Vol3
Below Status col it will be null
How can I get this sum printed only in last row.
If I use aggregator to seperately sum each column, how will i get the other 2 columns all in a same row and printed at last?
Thanks,
Harshada
I want to print sum of some of the columns as the last row whcih shows the total of all the data coming in a particular column.
for eg
LA Vol1 Date Vol2 Vol3 Status
A 10 23/Feb/2008 5 10 F
B 20 23/Feb/2008 5 10 F
C 10 23/Feb/2008 5 10 P
D 30 23/Feb/2008 5 10 P
4 70 20 50
The last row gives the total of col data except for date column and status column. the data is like
4 is sum of count of LA
70 is sum of Vol1
Below date col it will be null
20 is sum of Vol2
50 is sum of Vol3
Below Status col it will be null
How can I get this sum printed only in last row.
If I use aggregator to seperately sum each column, how will i get the other 2 columns all in a same row and printed at last?
Thanks,
Harshada