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