Date Summery

[drthorne1]

Hi Everyone

I am wanting to create a report that shows an overview of all the calls currently open - all call resolved and total calls logged to a specific team.

I want this to be listed by month and I only want to show the last 5 months from the current date.

The problem is that because my date is generated via a {submit date} field, when it does the count on the resolved calls it counts it even if it was not resolved in that month, so the figure is inaccurate.

Example

(date)September - Total calls logged in September 4 - Total calls Resolved in September 3 (when it should be 1) - Total calls Open 2


// Data for September - The data is suppressed in report//
Incident Number - Status - Last Resolved Date -
1233434 Open
3432454 Resolved 01/10/09
4545325 Open
4554645 Resolved 12/10/02
4545454 Resolved 02/09/03

Total calls logged in September 4
Total calls Resolved in September 3 (when it should be 1)
Total calls Open 2

What I need is a formula for the date group that is not generated by the submit date, and i am not sure how to do this, i guess i would then need to wright something that says -

If submitdate is the same as the grouped month the count it else don't

And the same for calls resolved - if resolved date is the same as the grouped month then count else don't.

Any ideas ?

Sorry if this does not make much sense, and I will try and provide me details if needed.