after function not working

[Siva_Sankar]

hi.

i would like to do the following in cross tab

Product	sales1	sales2	sales3	sale4	sale5	sale6
	100	200	350	120	200	500
	400	100	450	210	300	100
	500	300	150	321	400	100
total	1000	600	950	651	900
totsales for next 3 months			670	820

totalsales for next 3 months = current total sales+total sales of next two columns.

I used after of function and it didnt work. can anyone help?

Regards.

siva

[khadeer]

After function will work only on pivot table not for stright table.

[Siva_Sankar]

Yes, can you please let me know how to achieve this on pivot table.

[khadeer]

I hope accumaltion resolve ur prblm.