Hi,
Thank you for going thorugh my requirment, Please find below and provide a solution to acheive it.
|
Table Structure |
|
|
|
|
|
|
|
|
|
|
|
|
|
Country |
State |
City |
Age |
Male Population(PERC) |
Female Population(PERC) |
|
India |
Tamil Nadu |
Chennai |
18-25 |
92 |
82 |
|
India |
Tamil Nadu |
Madurai |
18-49 |
80 |
70 |
|
India |
Tamil Nadu |
Trichy |
25-45 |
72 |
69 |
|
India |
Tamil Nadu |
Osur |
39-60 |
56 |
61 |
|
India |
Karnataka |
Bangalore |
34-39 |
82 |
92 |
|
India |
Karnataka |
Mysore |
23-83 |
87 |
82 |
|
India |
Karnataka |
Mangalore |
63-91 |
62 |
72 |
|
India |
Karnataka |
Osur |
18-49 |
92 |
76 |
|
India |
Andhra |
Hyderabad |
25-45 |
73 |
63 |
|
India |
Andhra |
Guntur |
34-39 |
56 |
82 |
|
India |
Andhra |
Vijayawada |
18-49 |
83 |
53 |
|
India |
Maharastra |
Mumbai |
63-91 |
95 |
91 |
|
India |
Maharastra |
Pune |
23-83 |
73 |
75 |
|
India |
Maharastra |
Vijayawada |
16-52 |
53 |
83 |
Cross Tab :
|
Cross Tab Needs to be displayed in the below Format |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
India |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
18-49 |
25-45 |
34-39 |
|
|
|
18-49 |
23-83 |
34-39 |
63-91 |
|
|
|
16-52 |
23-83 |
63-91 |
|
|
|
18-25 |
18-49 |
25-45 |
39-60 |
|
Andhra |
Guntur |
|
|
56 |
|
Karnataka |
Bangalore |
|
|
82 |
|
|
Maharastra |
Mumbai |
|
|
95 |
|
Tamil Nadu |
Chennai |
92 |
|
|
|
|
|
Hyderabad |
|
73 |
|
|
|
Mangalore |
|
|
|
62 |
|
|
Pune |
|
73 |
|
|
|
Madurai |
|
80 |
|
|
|
|
Vijayawada |
83 |
|
|
|
|
Mysore |
|
87 |
|
|
|
|
Vijayawada |
53 |
|
|
|
|
Osur |
|
|
|
56 |
|
|
|
|
|
|
|
|
Osur |
92 |
|
|
|
|
|
|
|
|
|
|
|
Trichy |
|
|
72 |
|
I need to display the cross tab in the above format with the help of the Table structure given above.
Please go through and suggest a neccesary solution.
Regards,
San
IP Logged