Skip to Content
0
Former Member
Oct 27, 2009 at 04:02 PM

Problem in summarizing data in the group level

9 Views

I have four groups namely

i) Year Case opened.

ii) Month Case opened

iii) Case Status

iv Case Severity

In the details section there are few details for the report to show namely Case Severity (ie., Level 1, Level2 etc) and Case Status (ie., Opened, Closed and Pending).

In the Case Severity Level i am displaying the count. Till now everything is fine.

Now, a statistics for the month has to be added. I haved the fields in the Group Footer of Month Case Opened.

I need to calculate the total Case Severity of Level 1 in opened status and total of Level 2 in opened status and so on..

Only the last Case Severity value total is shown correctly in statistics of the month.

Please let me know if there is any suggestions on this.

Thanks in Advance.