5.6.3 crosstab - Sum each column

BI Publisher Desktop 10.1.3.2.1 using the CROSSTAB functionality -

I'm really not sure how to approach this, because the data is not grouped in a way that I can normally just use a for each with a "sum(amount)".

The data previews like this:       

Period Num	Period Name	Account	21550	21552	21553	21554	21555
1	1-JAN-2014		0	-7,891.90	0	-64	-110
2	2-JAN-2014		0	-8,985.57	0	-60	-138
3	3-JAN-2014		0	-6,422.82	0	-100	-65
4	4-JAN-2014		-5.88	-6,115.55	0	-40	-60
5	5-JAN-2014		0	-1,716.33	0	-70	0
6	6-JAN-2014		0	-663.11	0	0	-35
7	7-JAN-2014		0	-595.02	0	0	0
8	8-JAN-2014		0	-1,476.59	0	0	0

I need to get a sum of each of the account columns (21550, 21552, etc. (separately)) for the entire report at the bottom.  The XML data looks like this:

DAGRAREP>

<P_BEG_DATE>01-JAN-2011</P_BEG_DATE>

<P_END_DATE>15-DEC-2014</P_END_DATE>

<P_COMPANY>1340</P_COMPANY>