Hi,

How would I create a cumulative total for a total?

For eg:

Project Jan Feb Mar
ABC 1500 2500 3000
DEF 1000 1000 1000
Total 2500 3500 4000
Cum Total 2500 6000 10000 <---- How do I create this one

Thanks,
John

Is this for T-SQL or MDX? if for T-SQL you can use COMPUTE
SUM

HTH

Ray Higdon MCSE, MCDBA, CCNA

You're looking for some of the same things that i am - here's some links
from previsous postings:

304118 INF: How To Perform Time Series Calculations
http://support.microsoft.com/?id=304118

301637 INF: How to Calculate the Cumulative Value of a Measure
http://support.microsoft.com/?id=301637

"Ray Higdon" <rayhigdon (AT) higdonconsulting (DOT) com> wrote