All,
I have a requirement where i need to implement the same forumale to TOTAL as in the column calculations.
For eg: Column2=(Column1+50/100) then the total should be Total(column2)=(Total(Column1)+50/100).
Hope you got the point. How can i capture the total of the column then re use it for another TOTAL calculations.
Let me know if you have any solutions.
Regards
R.Prasanna

Calculate your column2 using a COMPUTE statement, then
ON TABLE SUMMARIZE
applies whatever COMPUTE's you are using to the GRANDTOTAL line.

Susannah,
I am having the columns which are created using DEFINE.Can you eloborate your steps more.I am not clear on your definiion.

Prasanna,
What Susannah is saying is that if you want to re-calculate at total time than you must use COMPUTE and not DEFINE. For totalling then use SUMMARIZE instead of SUBTOTAL or COLUMN-TOTAL.