Need 'Total Calculations' to show at the end of 'List View'

[jkazper]

I have a set of information that looks like this:

last first option1 option2 option3 total
jobitz, larry 22.00 41.01 33.05 96.06
largin, marv 14.03 12.22 21.20 47.45

how do i make it so that i can total every column and show up as if it
were the final entry in the list?

like this:

last first option1 option2 option3 total
jobitz, larry 22.00 41.01 33.05 96.06
largin, marv 14.03 12.22 22.20 48.45
--------------------------------------------
totals: 36.03 53.23 54.25 144.51



instead of like this:
last first option1 option2 option3 total
jobitz, larry 22.00 41.01 33.05 96.06
totals: 36.03 53.23 54.25 144.51
largin, marv 14.03 12.22 22.20 48.45
totals: 36.03 53.23 54.25 144.51


as of now, i have to make a seperate printout page that has the summary totals and line it up so that i can re-print the summary totals underneath
the last record in the list.

thanks for the help!!

 

[Schlogg]

Create a self-join (S-Join) using, say, gNum = 1 and MyNum =1. gNum is a Global and MyNum is an ordinary Number field.
Creat a set of Calculaton fields TotOptions01, ...02, etc.
TotOptions01 = Sum(S-Join::Option1)
The TotOptions fields are available virtually anywhere on your layout.

Cheers,
Paul J.