Cross table

[Sugarp]

Hello,

I need to create a cross table in Qlik sense, Current table structure is below, and wanted an output as below. Is it possible?

It shoud give me count of if where KNI is incomplete,ciritical is true,Outsourcing is Yes and Group is Yes.

How do I do that in pivot table so that I can get same format.

Also want to group KNI in 2 pack link below.

My table right now

ID	KNI_1	KNI_2	KNI_3	Critical	Outsourcing	Group	Countries
136936280	Incomplete	complete	Incomplete	TRUE	YES	Yes	India
110192957	Incomplete	complete	Incomplete	TRUE	YES	Yes	India
123711230	Incomplete	complete	Incomplete	FALSE	No	Yes	India
192122047	Incomplete	complete	Incomplete	FALSE	No	Yes	India
61976243	Incomplete	complete	complete	FALSE	No	Yes	US
114298790	Incomplete	complete	complete	FALSE	No	No	US
177766174	complete	complete	complete	TRUE	No	No	US
90938388	complete	complete	complete	FALSE	No	No	US
182210776	complete	complete	complete	TRUE	No	No	UK
104968900	complete	complete	complete	TRUE	Yes	No	UK
113302616	complete	complete	complete	TRUE	Yes	No	UK

Result should be

PACK1	KNI_1(Incomplete)		India	US	UK
		Critical=TRUE	2	1	0
		Outsourcing=Yes	4	1	4
		Group=Yes	8	5	5
	KNI_2	Critical=TRUE	9	2	5
		Outsourcing=Yes	3	9	7
		Group=Yes	9	7	10
PACK2	KNI_3	Critical=TRUE	6	10	5
		Outsourcing=Yes	10	1	1
		Group=Yes	2	6	10