Total column example (excel-0001)

In this example I will show how a total column can be achieved by using excel formula.
This example has the sample data copied from oracle sample "World Sales", see the following xml:
<?xml version='1.0' encoding='UTF-8'?>
<SALES>
<SALE>
<REGION>Americas</REGION>
<SOFTWARE>1200</SOFTWARE>
<HARDWARE>850</HARDWARE>
<SERVICES>2000</SERVICES>
</SALE>
<SALE>
<REGION>EMEA</REGION>
<SOFTWARE>1000</SOFTWARE>
<HARDWARE>800</HARDWARE>
<SERVICES>1100</SERVICES>
</SALE>
<SALE>
<REGION>APAC</REGION>
<SOFTWARE>900</SOFTWARE>
<HARDWARE>1200</HARDWARE>
<SERVICES>1500</SERVICES>
</SALE>
</SALES>

The end report we want to be displayed like the following:

Now the RTF template:


INIT
<?xdoxslt:set_variable($_XDOCTX, 'row', 1)?>
F
<?for-each:SALE?>
INC
<?xdoxslt:set_variable($_XDOCTX, 'row', xdoxslt:get_variable($_XDOCTX, 'row') + 1)?>
REGION
<?REGION?>
SOFTWARE
<?SOFTWARE?>
HARDWARE
<?HARDWARE?>
SERVICES
<?SERVICES?>
XLS_FORMULA
=B<?xdoxslt:get_variable($_XDOCTX, 'row')?> +C<?xdoxslt:get_variable($_XDOCTX, 'row')?> +D<?xdoxslt:get_variable($_XDOCTX, 'row')?>
E
<?end for-each?>