Issue with Summarizing Status Count

[rocky09]

See below table, I have cat. column, where Users start working on each cat. and change the status to Inprogress, Complete and some times rework.

So, if a Cat. worked on 5 days and status will be In progress for 5 days, on 6th day , the work was completed. So, the status will becomes Completed.  Now, I am trying to count of Status.

Logic is:

* If any of the Cat. has Completed. The Cat. will show under Completed and it should counts only one.

* If any of the Cat. is still In Progress, the Cat. will show InProgress status and it should take count as one every it has 10 Previous inprogress days.

*Same logic appicable to rework.

See my sample data and the solution i am expecting.

Date	Cat.	Status
2-Oct-17	alpha_9383993	In Progress
3-Oct-17	Pulse_9387388	In Progress
4-Oct-17	Pulse_9387388	Rework
5-Oct-17	alpha_9383993	In Progress
6-Oct-17	alpha_9383993	Completed
7-Oct-17	Pulse_9387388	Completed
8-Oct-17	Oppo_tes_9383	In Progress
9-Oct-17	Oppo_Max_8977	Rework

Status	Count
Completed	2
In Progress	1
Rework	1