count cell in column for last 5 days with diffrent conditions

[manoj_arsul]

I want program for the below condition.(Last 5 Days Count City wise .) ....( eg .Today is -19th July)


1) Filter to Column "A" Status For Working .
2) Filter to Column "B" City For Pune.
3) Get Till date (Today) Count of column "A" in the cell of table ( Today 19th)
4) Filter Today()-1 & Get date Count of column "A" in the cell of table ( 18th July)
5) Filter Today()-2 & Get date Count of column "A" in the cell of table ( 17th July)
6) Filter Today()-3 & Get date Count of column "A" in the cell of table ( 16th July)
7) Filter Today()-4 & Get date Count of column "A" in the cell of table ( 15th July)

Do the Same condition with other Pending , Pending - Not OK , Waiting

Source Data: -

Status*	City	Country	Test	Date
Pending	Pune	India	Ok	19-Jul-18
Pending	Mumbai	India	Ok	17-Jun-18
Pending - Not OK	London	England	Not OK	16-May-18
Pending - Not OK	Pune	India	Not OK	15-Jul-18
Pending	Mumbai	India	Ok	18-Jul-18
Pending - Not OK	Mumbai	India	Not OK	19-Jul-18
Pending - Not OK	London	England	Not OK	17-Jul-18
Pending - Not OK	Pune	India	Not OK	16-Jul-18
Waiting	London	England	Ok	15-Feb-18
Waiting	Pune	India	Ok	18-Jul-18
Waiting	Mumbai	India	Not OK	19-Jul-18
Waiting	London	England	Not OK	17-Jul-18
Waiting	Pune	India	Ok	16-Jun-18
Working	Mumbai	India	Ok	5-Mar-18
Working	London	England	Not OK	18-Jul-18
Working	Pune	India	Ok	19-Jul-18
Working	Pune	India	Ok	17-Mar-18
Closed	London	England	Not OK	16-Jul-18
Closed	London	England	Not OK	15-Jul-18
Closed	Pune	India	Not OK	18-Jul-18
Closed	Mumbai	India	Not OK	19-Jul-18
Closed	London	England	Ok	17-Jul-18
Closed	Pune	India	Ok	16-Jul-18
Closed	Mumbai	India	Not OK	15-Jul-18
Closed	London	England	Not OK	18-Jul-18

<tbody>
</tbody>

Out Put :

Pune	Working Count	Pending Count	Pending - Not OK	Waiting Count
15-Jul-18	0	0	1	0
16-Jul-18	0	0	2	1
17-Jul-18	1	0	2	1
18-Jul-18	1	0	2	2
19-Jul-18	2	1	2	2

<tbody>
</tbody>