Date: Tue, 23 Jan 2007 13:30:38 +0000
Reply-To: toby dunn <tobydunn@HOTMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: toby dunn <tobydunn@HOTMAIL.COM>
Subject: Re: How to Get Till Date (Rolling Total) in MDX?
Content-Type: text/plain; format=flowed
Fix the Subject line it should be accumulative sum not rolling sum. And you
want the cummulative sum by some other variable which you havent listed.
This is why we ask for sample start data and what you are expecting data
To sensible men, every day is a day of reckoning. ~John W. Gardner
The important thing is this: To be able at any moment to sacrifice that
which we are for what we could become. ~Charles DuBois
Don't get your knickers in a knot. Nothing is solved and it just makes you
walk funny. ~Kathryn Carpenter
From: amit <amitps@GMAIL.COM>
Reply-To: amit <amitps@GMAIL.COM>
Subject: How to Get Till Date (Rolling Total) in MDX?
Date: Mon, 22 Jan 2007 22:43:30 -0800
How to Get Till Date (Rolling Total) in MDX?
We have MTD & YTD functions which give month to date & year to date
values. I want a MDX formula which will calculate value of a member
from start till date for each year (Rolling Total). E.g. If we have
data for years 2004, 2005, 2006 and we require [New Calculated Measure]
as shown below
Year Amount [New Calculated Measure]
2004 100 100
2005 500 600
2006 800 1400
Get in the mood for Valentine's Day. View photos, recipes and more on your