Set Expression

[upaliwije]

I have created a document and attached the same herewith. In this document I have two pivot table names 'Correct one'  and 'New One'

In this New One pivot table I want the data to appear like as given below

YEAR	JAN_NRP	FEB_NRP	MAR_NRP	APR_NRP	MAY_NRP	JUN_NRP	JUL_NRP	AUG_NRP	SEP_NRP	OCT_NRP	NOV_NRP	DEC_NRP
2013	4,122,270	5,225,041	5,436,199	3,911,853	5,017,381	3,978,719	4,813,178	4,772,933	5,844,202	4,616,779	4,843,327	3,715,368

The above figures are the data shown in Pivot Table (correct one)  against the respective month No rwos

Pls help me to solve this problem

[its_anandrjs]

Please clear your requirement with more sample data it is not clear.

[upaliwije]

Hi Anand

Thanks

My requirement is to overwrite the existing data in the New one pivot table with highlighted data in the attached table

Correct One
YEAR	MONTH	JAN_NRP	FEB_NRP	MAR_NRP	APR_NRP	MAY_NRP	JUN_NRP	JUL_NRP	AUG_NRP	SEP_NRP	OCT_NRP	NOV_NRP	DEC_NRP
2013	1	4,122,270	5,139,520	6,129,330	4,060,620	5,332,799	4,778,475	5,820,451	4,327,208	4,492,297	5,708,382	5,472,065	5,573,470
2013	2	4,122,270	5,225,041	6,129,330	4,060,620	5,332,799	4,778,475	5,820,451	4,327,208	4,492,297	5,708,382	5,472,065	5,573,470
2013	3	4,122,270	5,225,041	5,436,199	4,060,620	5,332,799	4,778,475	5,820,451	4,327,208	4,492,297	5,708,382	5,472,065	5,573,470
2013	4	4,122,270	5,225,041	5,436,199	3,911,853	5,332,799	4,778,475	5,820,451	4,327,208	4,492,297	5,708,382	5,472,065	5,573,470
2013	5	4,122,270	5,225,041	5,436,199	3,911,853	5,017,381	4,778,475	5,820,451	4,327,208	4,492,297	5,708,382	5,472,065	5,573,470
2013	6	4,122,270	5,225,041	5,436,199	3,911,853	5,017,381	3,978,719	5,820,451	4,327,208	4,492,297	5,708,382	5,472,065	5,573,470
2013	7	4,122,270	5,225,041	5,436,199	3,911,853	5,017,381	3,978,719	4,813,178	4,327,208	4,492,297	5,708,382	5,472,065	5,573,470
2013	8	4,122,270	5,225,041	5,436,199	3,911,853	5,017,381	3,978,719	4,813,178	4,772,933	4,492,297	5,708,382	5,472,065	5,573,470
2013	9	4,122,270	5,225,041	5,436,199	3,911,853	5,017,381	3,978,719	4,813,178	4,772,933	5,844,202	5,708,382	5,472,065	5,573,470
2013	10	4,122,270	5,225,041	5,436,199	3,911,853	5,017,381	3,978,719	4,813,178	4,772,933	5,844,202	4,616,779	5,472,065	5,573,470
2013	11	4,122,270	5,225,041	5,436,199	3,911,853	5,017,381	3,978,719	4,813,178	4,772,933	5,844,202	4,616,779	4,843,327	5,573,470
2013	12	4,122,270	5,225,041	5,436,199	3,911,853	5,017,381	3,978,719	4,813,178	4,772,933	5,844,202	4,616,779	4,843,327	3,715,368