hi,
am facing these problems in one of my  projects  and  i will be grateful if you guys can be of help.
   
      BEN      ANDY    JOE    FRANK    TOTAL   PREVIOUS TOTAL    CUMULATIVE
AB      23         4          6        7             40   

CD       4         5           8        9             26

EF        6          7          8        1             22

TOTAL  33       16         22      17          88

I want the CUMULATIVE TOTAL to be equal to TOTAL + PREVIOUS TOTAL

and PREVIOUS TOTAL equal to PREVIOUS CUMULATIVE TOTAL

THUS: CUMULATIVE=TOTAL+PREVIOUS TOTAL

          PREVIOUS TOTAL= PREVIOUS CUMULATIVE

Am using Cross Tab

what formulas should i use for the Previous Total and Cumulative Total Sections.