Hello Guys
I got two Pivot tables and i need to merge them to one.
Count of TS_NAME Count of TS_NAME
ACTUAL_EXECUTION_DATE Total START_DATE Total
23/02/2010 12 12 24
26/02/2010 8 2/03/2010 24
1/03/2010 2 3/03/2010 32
2/03/2010 32 4/03/2010 33
3/03/2010 42 5/03/2010 33
4/03/2010 19 9/03/2010 46
5/03/2010 31 10/03/2010 40
9/03/2010 28 11/03/2010 34
10/03/2010 63 12/03/2010 42
11/03/2010 32 15/03/2010 40
12/03/2010 20 16/03/2010 115
15/03/2010 33 17/03/2010 66
16/03/2010 35 18/03/2010 51
17/03/2010 42 19/03/2010 37
18/03/2010 6 22/03/2010 1
19/03/2010 6 23/03/2010 3
22/03/2010 22 27/03/2010 3
23/03/2010 11 28/03/2010 26
24/03/2010 25 30/03/2010 1
25/03/2010 31 31/03/2010 2
(blank) 281 (blank) 128
Grand Total 781 Grand Total 781
i need in this format.
Date Total Actual exec Total start
23/02/2010 12 0
24/02/2010 0 0
25/02/2010 0 0
26/02/2010 8 0
27/02/2010 0 0
28/02/2010 0 0
1/03/2010 2 24
2/03/2010 32 24
3/03/2010 42 32
Bookmarks