Mythorth

Hi, i hope this helps to understand what i need: Code: COL1 COL2 Col3 COL4 ITEM1 W X Y Z Accumulated =W =W+X =W+X+Y =W+X+Y+z

Hi, thanks for your hint, but what i am looking for is not the Total Column. Just an example: ITEM1 February must be ITEM1(JAN) + ITEM1(FEBR) ITEM1 March must be ITEM1(JAN) + ITEM1(FEBR) + ITEM1(MAR) And this for every Line so this is what you see in the Accumulated Rows in my sample Table. Post edited by: Mythorth, at: 2008/04/30 07:37

Hi, i have got a problem insering an accumulated value line into my crosstab, it should look like this: Code: JAN FEB MAR TOTAL ITEM1 3 2 5 10 Accum. 3 5 10 10 ITEM1 1 8 0 9 Accum. 1 9 9 9 How can i realise to get the accumulated values? Can i use the value of the cell from the previous column in a crosstab to make something like "value = current column + previous column"? Or can i store the value of the current cell outside the crosstab data in a variable to use it for calculation in any way? I am sure there is an easy way to realise this and i just don't get it so thanks for your help in advance.