Display total count of incidents in "pending" status with X created date

Content

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,

Seethalakshmi S

 

 

Edited by eleep to have a more specific subject title.