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.