sql server data warehouse: End Date . . . ? -- sql server data warehouse

End Date . . . ?

GGill
9/11/2007 9:02:04 AM

sql server data warehouse:

The date i select from my report to pull data 'End Month Date'. I need to
calculate my 'TotalAmount' base on my 'End Month Date' and previous 'End
Month Date'. For example:
if i selected '20070831' and 'TotalAmount'= '100', base on my selected date
i need to get 'TotalAmount' from previous 'End Month Date'. For example
previous 'End Month Date' the 'TotalAmount' = '80'. 100-80=20.
what parameter should i use to get 'TotalAmount' from previous 'End Month
Date' in my expression???

Re: End Date . . . ?

Jeje
9/12/2007 12:00:00 AM

which tool do you use?
reporting services?
do you write an SQL query or MDX query?
and describe the database or cube model.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server data warehouse group.