Display total count of incidents in "pending"...

Hi All,

I have a requirement to create an incident report based on the below conditions with these columns
1.Date/time
2.Reference number
3.Carry over
4.Incident Created
5.Total Created Incident
6.Closed Status
7.Pending status

In the attached report image, I am getting the total count of "closed" and "pending" status of daily created incident.

I want to display the total count of the "pending status" of previous created date in the next column of carry over column(Variable)

Thanks in Advance,
Priya

Zircon - This is a contributing Drupal Theme
Design by WeebPal.