Hello

I have a sales measure in the cube.

The requirement is for the client to enter a date range and get cumulative
sales figures for each date in the range.

I am aware that providing a range is not an easy task and have decided to
provide a single date instead.

So what i need to do is get a date from the client, and use that date - 90
days (or - 3 months) to get the start date.

I need help with

1. calculating the start date?
2. calculating cumulative sales for each day, but with the first day sales
showing sales ON that day
3. calculating cumulative sales for each day, with the first day sales also
cumulative.


thanks very much

--
Message posted via http://www.sqlmonster.com