Ok thanks for the comments.

The business rule is explained below

This is basically a statistical report for a small and medium enterprise.

With this report user should be able to judge the growth of the business.

The output has 4 parts.

User only provides month and year as input. Say he provides 201303

There is only one input thats the date and month

Part 1 (this is for selected year - 201303)

System should display the count of ENTERPRISE_MAIN_CODE and the amount associated to the ENTERPRISE_MAIN_CODE

Table c data : 1 2 20130315 2000

the output should be A (enterprise_description) 1(count) 2000(amount)

Part 2(this is for previous year – 201203)

System should display the count of ENTERPRISE_MAIN_CODE and amount associated to the ENTERPRISE_MAIN_CODE

Table c data : 2 4 20120305 4000

the output should be A (enterprise_description) 1(count) 4000(amount)

Part 3 (this is for selected year – from 20130101 - 20130330)

System should display the count of ENTERPRISE_MAIN_CODE and the amount associated to the ENTERPRISE_MAIN_CODE

Table C data 1 1 20130109 1000

1 2 20130315 2000

Start counting from 01/01/2013 till 30/03/2013

the output should be A (enterprise_description) 2(count) 3000(amount)

Part 4 (this is for previous year – from 20120101 - 20120330)

System should display the count of ENTERPRISE_MAIN_CODE and the amount associated to the ENTERPRISE_MAIN_CODE

Table C data 2 3 20120120 3000

2 4 20120305 4000

Start counting from 01/01/2012 till 30/03/2012

the output should be A (enterprise_description) 2(count) 7000(amount)

Hope its clear to you

Thanks

Nick