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???

Thank you.

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

"GGill" <GGill@discussions.microsoft.com> wrote in message
news:88FE1B37-E580-465B-A57A-759F132053ED@microsoft.com...
> 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???
>
> Thank you.