Sum across a row in crosstab...

Hi all,

I have a cross a tab, where months are in horizontal axis,codegrups are in vertical axis and quantity in body.

2008SEP 2009OCT 2010FEB 2010MAR 2010JUN 2010JUL 2010AUG 2010SEP 2010OCT 2010DEC 2011JAN 2011FEB 2011MAR 2011APR 2011JUN 2011JUL 2011AUG 2011OCT Total: G1 1 1 2 2 3 3 1 2 2 17 G2 1 1 G3 1 1 1 1 1 2 1 1 2 1 1 1 1 15 G4 1 1 3 2 1 1 1 10 G5 1 1

Total Quantity(sum)

1 1 1 1 4 2 2 4 1 3 7 3 5 1 4 2 1 1 44 dispatch qty 13460 30379 38703 49576 169176 88696 81632 131424 15545 99552 304073 128106 179280 28525 108720 62090 35234 36037 1600208 Total Dispatched(Dispatch qty/Total qty) 13460 30379 38703 49576 42294 44348 40816 32856 15545 33184 43439 42702 35856 28525 27180 31045 35234 36037

Here, all i needed is the sum across the "total dispatch" row, I tried with running sum, but am not getting the correct value.

Request you to kindly help mo on this..

Thanks,

Malathi