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
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,

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