Accumulated Values in Crosstabs

[Mythorth]

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.

[burasami]

just create a cross tab. and check add column total and row total while u design the cross tab report. i think this may help u.

[Mythorth]

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

[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

[mauricio]

Hello, I know it's some time ago for this ... but, did you find an answer for this ?

please share

thanks