WEBI Report with Previous Month

Hi,

I am creating a report with fields like (year, month revenue, previous month revenue and variance between those 2 months). i have a date prompt in my repot. i need to select the month and previous month from that prompt dynamically.

I know how to get the month from the date prompt, but how can i get the previous month and corresponding revenue value.

any suggestions please send.

Thanks.

Edited by: shahin13 on Jul 15, 2011 12:18 PM