Display Prior Month Revenue along with Current Month Rev

48 Views

Hi All,

My requirement is need to display the revenue along with PriorMonth revenue when user selects any business month date.

My data like as below

Country Business Date Revenue
USA 31/01/2010 5000
USA 28/02/2010 6000
USA 28/02/2010 4000
USA 31/03/2010 4000
UK 31/01/2010 2000
UK 28/02/2010 1000
UK 31/03/2010 3000
INDIA 31/01/2010 3000
INDIA 28/02/2010 8000
INDIA 31/03/2010 8000
INDIA 31/03/2010 9000

Note: Montly Data (Last day of the month of the year is the Business Date).

I need a report like as below

Date Prompt as User choice through calaendor (User should select lase day of the month through calendor)

If user selects Date as : 28/02/2010 . The data should disply as below

Results:

Country Business Date CM Revenue PM Revenue Status

USA 28/02/2010 10000 5000 Increased
UK 28/02/2010 1000 2000 Decreased
INDIA 28/02/2010 8000 8000 No change

Please provide a solution how to achieve this.

Thank you very much .