You can use the sum function
in FormCalc to total the values in a column. You must add the calculation
to the footer row of the table.
Select the cell in the footer row where you want the
calculation. For example, select the cell that corresponds to the
total for Q1.
In the Script Editor, select Calculate from the Show list.
In the Language list, select FormCalc.
In the Run At list, select Client.
In the Script Source field, insert your FormCalc calculation.
For example, to calculate the total for the Q1 data, type the following
expression:
sum (Table.Row[*].Q1[*])
Repeat for the totals for Q2 and Q3.
To calculate the totals for the country, type the following
expression:
sum(Q1 + Q2 + Q3)
Repeat for the remaining row totals.
For the grand total, type the following expression:
sum(TotalQ1 + TotalQ2 + TotalQ3)
To show the data as 10K, in the Object palette, click the Cell tab, click Patterns, and type z9'K' in the Pattern box. In the Value tab, select Calculated - Read Only from the Type list.
|
|
|