Running sum -- sql server reporting services

Claus Aaberg
7/23/2004 1:56:04 PM

I'm not quite sure if i'm aiming for the impossible, but:

In a matrix, i have time (weeks) as columns, items as rows and qty as detail
and i would like to have a running sum for the columns.

This problems arise because i need to columns to be dynamic.

Any suggestions would be more than welcome

Example:

Records:
Item 1, week 1, qty 5
Item 1,week 2, qty 3
Item 1, week 3, qty 4

Matrix
week 1 week 2 week 3
Item 1 5 8 12

Claus Aaberg
7/23/2004 3:07:16 PM

I seem to have found the solution (RunningValue(Expression, Function,
Scope)).

Sorry for the inconvenience

[quoted text, click to view]

sql server reporting services : Running sum