G
Guest
i am pasting the content for hte pivot generated. Its
haphazzard but stil if anyone can understand an help me..
Under data i have:
Sum of HRQ1 04/05
Sum of HRQ2 04/05
Sum of HRQ3 04/05
Sum of HRQ4 04/05
Count of LOCATION NEW2
and then their sums...
Total Sum of HRQ1 04/05
Total Sum of HRQ2 04/05
Total Sum of HRQ3 04/05
Total Sum of HRQ4 04/05
Total Count of LOCATION NEW2
can it be possible to have each total's below each sum's
instead all in hte end
T-TCR2003
Data LOCATION NEW A360 A565 A5XX Catalyst
J750 / J971 Other Sync GSM / Fusion HT
Sync PVI / Fusion PPS T6673
Sum of HRQ1 04/05 ASE
1,633 9,068 23,371
Batam Island 21,737 32,430
919 8,961 5,034 18,967
SINGAPORE 6,341 24,526
18,765 60,416 7,031 72,546 15,151
398
STATS 20,319
4,047
SUBCON 7,023
UTAC 1,298 4,518
1,304 1,362
Sum of HRQ2 04/05 ASE
796 6,856 17,895
Batam Island 22,610 33,273
683 9,052 5,771 16,448
SINGAPORE 7,717 26,219
19,576 53,030 5,799 78,196 16,296
439
STATS 14,908
3,980
SUBCON 9,412
UTAC 1,350 3,280
- 1,364
Sum of HRQ3 04/05 ASE -
6,216 12,662
Batam Island 22,436 33,135
1,071 8,351 5,991 16,155
SINGAPORE 8,367 20,558
26,675 58,202 5,284 81,355 17,920
405
STATS 10,578
3,476
SUBCON 9,584
UTAC 617 1,627
- 1,301
Sum of HRQ4 04/05 ASE -
3,005 6,575
Batam Island 15,322 22,344
677 5,747 3,757 10,859
SINGAPORE 5,887 10,749
21,106 37,982 3,295 56,585 11,455
280
STATS 4,390
2,333
SUBCON 6,867
UTAC 229 305
- -
Count of LOCATION NEW2 ASE 2
4 5
Batam Island 91 146 10
69 18 30
SINGAPORE 8 60 49
219 30 122 24 3
STATS 8
4
SUBCON 15
UTAC 1 2
2 3
Total Sum of HRQ1 04/05 21,737 45,794
25,446 42,014 74,002
15,992 106,302 35,480 398
Total Sum of HRQ2 04/05 22,610 50,403
26,902 36,630 63,165
14,851 105,843 34,107 439
Total Sum of HRQ3 04/05 22,436 51,086
21,629 37,871 66,045
13,636 103,484 35,376 405
Total Sum of HRQ4 04/05 15,322 35,099
11,426 25,726 41,292
9,042 69,249 22,315 280
Total Count of LOCATION NEW2 91 169
70 60 225 99 151 57 3
haphazzard but stil if anyone can understand an help me..
Under data i have:
Sum of HRQ1 04/05
Sum of HRQ2 04/05
Sum of HRQ3 04/05
Sum of HRQ4 04/05
Count of LOCATION NEW2
and then their sums...
Total Sum of HRQ1 04/05
Total Sum of HRQ2 04/05
Total Sum of HRQ3 04/05
Total Sum of HRQ4 04/05
Total Count of LOCATION NEW2
can it be possible to have each total's below each sum's
instead all in hte end
T-TCR2003
Data LOCATION NEW A360 A565 A5XX Catalyst
J750 / J971 Other Sync GSM / Fusion HT
Sync PVI / Fusion PPS T6673
Sum of HRQ1 04/05 ASE
1,633 9,068 23,371
Batam Island 21,737 32,430
919 8,961 5,034 18,967
SINGAPORE 6,341 24,526
18,765 60,416 7,031 72,546 15,151
398
STATS 20,319
4,047
SUBCON 7,023
UTAC 1,298 4,518
1,304 1,362
Sum of HRQ2 04/05 ASE
796 6,856 17,895
Batam Island 22,610 33,273
683 9,052 5,771 16,448
SINGAPORE 7,717 26,219
19,576 53,030 5,799 78,196 16,296
439
STATS 14,908
3,980
SUBCON 9,412
UTAC 1,350 3,280
- 1,364
Sum of HRQ3 04/05 ASE -
6,216 12,662
Batam Island 22,436 33,135
1,071 8,351 5,991 16,155
SINGAPORE 8,367 20,558
26,675 58,202 5,284 81,355 17,920
405
STATS 10,578
3,476
SUBCON 9,584
UTAC 617 1,627
- 1,301
Sum of HRQ4 04/05 ASE -
3,005 6,575
Batam Island 15,322 22,344
677 5,747 3,757 10,859
SINGAPORE 5,887 10,749
21,106 37,982 3,295 56,585 11,455
280
STATS 4,390
2,333
SUBCON 6,867
UTAC 229 305
- -
Count of LOCATION NEW2 ASE 2
4 5
Batam Island 91 146 10
69 18 30
SINGAPORE 8 60 49
219 30 122 24 3
STATS 8
4
SUBCON 15
UTAC 1 2
2 3
Total Sum of HRQ1 04/05 21,737 45,794
25,446 42,014 74,002
15,992 106,302 35,480 398
Total Sum of HRQ2 04/05 22,610 50,403
26,902 36,630 63,165
14,851 105,843 34,107 439
Total Sum of HRQ3 04/05 22,436 51,086
21,629 37,871 66,045
13,636 103,484 35,376 405
Total Sum of HRQ4 04/05 15,322 35,099
11,426 25,726 41,292
9,042 69,249 22,315 280
Total Count of LOCATION NEW2 91 169
70 60 225 99 151 57 3