I have the table data like this

 

Project	Type	Sub_Type	Count
IT-Project	Web	C#	2
It-Project	Web	Vb.net	3
IT-Project	Windows	C#	5
IT-Project	Windows	Vb.net	8
Maintanence	Windows	C#	10
Maintanence	Windows	Vb.net	6

I need the report that should be like this

	Web	Windows
IT-Project	C# - 2 Vb.net-3	C# -5 Vb.net- 8
Maintenance	-	C# -10    Vb.net-6

 

 

 

 

 

 

 

How I can get it in Cross Tab. I tried like this in cross Tab.

 

Rows – Project

Columns –Type

Summary columns – {SubType +”-“+Count}
 

But I did not get the desired output. The Project, Type and subtype will be increasing…

Please anybody help me