Microsoft Excel - Excel pivot problem-urge

hi,

 i need urgent help on excel , i want preparia some data .like metion below .i have two table, one  poor rating data engg wise where i have only poor rating data, other table having total survey where all engg srvey data i want next table where i prepair all Percentage of poor rating eng wise.but some engg`s name no poor rating but having survey . how i  put formula in excel for prepairing this sheet

	Poor rating															Total Survey													Percentage of poor rating eng wise
Count of dserial	SURVEY MONTH													Count of Serial	SURVEY MONTH
Engineer ID	Apr`12	MAY'12	Jun`12	Jul`12	Aug`12	Sep`12	Oct`12	Nov`12	Dec`12	Jan`13	Feb`13	Grand Total		Engineer ID	Apr`12	MAY'12	Jun`12	Jul`12	Aug`12	Sep`12	Oct`12	Nov`12	Dec`12	Jan`13	Feb`13	Grand Total			Apr`12	MAY'12	Jun`12	Jul`12	Aug`12	Sep`12	Oct`12	Nov`12	Dec`12	Jan`13	Feb`13
aqE001	1			5	1		1					8		aqE001	6	5	3	8	7	5	2	1	5	4		46		aqE001	17%	0%	0%	63%	14%	0%	50%	0%	0%	0%	#DIV/0!
aqE017		1										1		aqE017	4	1		2			2		1	2		12		aqE017	0%	100%	####	0%	####	####	0%	####	0%	0%	#DIV/0!
aqE029	1		4	9	4	2		3	1		1	25		aqE029	26	29	27	29	18	13	11	9	15	15	13	205		aqE029	4%	0%	15%	31%	22%	15%	0%	33%	7%	0%	8%
aqE040	2	2	3	3			1	1		2	2	16		aqE037			1									1		aqE037	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%
aqE043	2		2	5	1	2		1	3		1	17		aqE040	8	11	17	19	5	7	10	5	5	10	6	103		aqE040	25%	18%	18%	16%	0%	0%	10%	20%	0%	20%	33%
aqE044	3			4		1	1	4			2	15		aqE043	15	10	36	35	7	18	10	4	20	16	20	191		aqE043
aqE049				1	3							4		aqE044	16	5	5	18	2	4	6	6	6	5	4	77		aqE044
aqE065			3	1		2	1			1		8		aqE045	1	1		1							1	4		aqE045
aqE087											4	4		aqE049	8	15	16	18	4	6	4	1	11	8	11	102		aqE049
ds01446		2	7	2	1							12		ds01249	4	11	12	17	4	9	7	7	11	7	10	99		ds01249
ds01452			3	1								4		ds01304	2	5	40	47	14	32	23	25	30	38	28	284		ds01304
ds01460	1	2	2	9	3	5	2			2		26		ds01309	48	59	48	52	23	20	17	17	31	34	41	390		ds01309
ds01477						2	1				1	4		ds01332						1	3	3	8	10	3	28		ds01332
T00838							1					1		ds01336	16	31	30	34	9	10	19	16	24	23	25	237		ds01336
V00837	4	1	3	4			1		1			14		ds01338	12	23	28	33	7	17	5	6	20	30	17	198		ds01338
Y00762	3	1	4		2	2	1		1			14		ds01347	24	26	42	33	15	14	17	17	30	39	24	281		ds01347
Grand Total	61	40	99	147	48	79	57	37	47	49	43	707		ds01349	12	13	12	12	6	12	5	7	8	19	10	116		ds01349
														ds01351	18	23	39	34	7	21	4	8	16	29	20	219		ds01351
														ds01394	21	20	25	25			8	6	18	13	11	147		ds01394
														ds01446	1	3	11	13	1				1			30		ds01446
														ds01452	2	3	10	12	1	2		4	1	7		42		ds01452
														ds01460	20	20	28	17	10	14	13	7	11	13	17	170		ds01460
														ds01477						2	1	1	5	5	7	21		ds01477
														T00838							1					1		T00838
														V00837	13	17	19	22	8	8	5	6	4	13	11	126		V00837
														Y00762	12	15	25	15	12	16	8	3	9	11	7	133		Y00762
														Grand Total	651	707	977	1046	369	507	399	374	681	809	719	7239

Hello usha,
I have assumed that you data layout is exactly as shown on one sheet with one column between tables.  Your first calculated cell will be AD4.  The following formula copied down and across will do what you want leaving blanks where appropriate.
=IF(ISNA(VLOOKUP($AC4,$A$4:$M$19,COLUMN()-COLUMN($AB$4),0)),"",IF(P4>0,VLOOKUP($AC4,$A$4:$M$19,COLUMN()-COLUMN($AB$4),0)/VLOOKUP($AC4,$O$4:$Z$29,COLUMN()-COLUMN($AB$4),0),""))
Regards
Harry

 
Thank you so much it`s works