Hello,
How could i convert the following data via pivote table :
Data :
SKU Code(11 Digit) Product Name Jan-08 Feb-08 Mar-08 Apr-08 Total 2008 Jan-09 Feb-09 Mar-09 Apr-09 Total 2009
CNCFR100-10 Female 1-Natural Black 80106 386403 110621 1362201 5879585.988 689720.3722 619943.6867 597896.3552 576916.6667 5622831.515
CNCFR100-11 Female 1-Promo 931857 145718 0 0 1077575 1155253
CNCFR100-12 Female 1-Promo 931857 145718 0 0 1077575 1002785
1943820 677839 110621 1362201 8034735.988 689720.3722 619943.6867 597896.3552 576916.6667 7780869.515
CNCFR316-10 Female 3.16-Burgandy 28999 195168 225726 434421 2720229.552 352880.1904 317180.4909 306625 295166.6667 2822568.657
CNCFR316-11 Female 3.16-Promo 517270 67901 0 585171 610698
CNCFR316-12 Female 3.16-Promo 517270 67901 0 585171 483270
1063539 330970 225726 434421 3890571.552 352880.1904 317180.4909 306625 295166.6667 3916536.657
CNCFR300-10 Female 3-Darkest Brown 42551 170987 97118 543041 2713162.994 320800.1731 288345.9008 278750 268333.3333 2670023.899
CNCFR300-11 Female 3-Promo 447764 73779 0 521543 625264
CNCFR300-12 Female 3-Promo 447764 73779 0 521543 483270
938079 318545 97118 543041 3756248.994 320800.1731 288345.9008 278750 268333.3333 3778557.899
CNCFR460-10 Female 4.6-Dark Red(TBL 11 04) 7908 14739 16504 32060 218375.316 16040.00866 14417.29504 15353.6448 13416.66667 59227.61516
CNCFR460-10 Female 4.6-Dark Red-Promo 54800 18352 73152 13571.5
62708 33091 16504 32060 291527.316 16040.00866 14417.29504 15353.6448 13416.66667 72799.11516
Pivot required :
Jan Feb Mar Apr
Female 1-Natural Black 2005 299,859 177,069 153,433 329,871
2006 83,233 332,404 319,120 108,759
2007 499,492 279,467 144,003
2008 80,106 386,403 110,621 1,362,201
2009 0 0 597,896 576,917
Female 1-Promo 2005 0 0 0 0
2006 361,743 13,269 1,368 469,015
2007 805,722 773,304
2008 931,857 145,718 0 0
2009
Female 3.16-Burgandy 2005 246,367 137,190 133,719 239,674
2006 45,229 225,656 171,845 56,569
2007 256,960 178,280 37,667
2008 28,999 195,168 225,726 434,421
2009 0 0 306,625 295,167
Female 3.16-Promo 2005 0 0 0 0
2006 253,963 20,462 6,451 364,898
2007 487,151 494,596
2008 517,270 67,901 0
2009
Female 3-Darkest Brown 2005 168,521 106,879 87,623 176,492
2006 34,455 132,350 148,627 54,048
2007 223,375 136,283 48,584
2008 42,551 170,987 97,118 543,041
2009 0 0 278,750 268,333
Female 3-Promo 2005 0 0 0 0
2006 192,993 8,227 1,062 277,122
2007 383,021 376,339
2008 447,764 73,779 0
2009
Female 4.6-Dark Red(TBL 11 04) 2005 49,857 21,659 22,565 45,286
2006 7,896 22,681 19,039 3,807
2007 37,235 17,977 10,896
2008 7,908 14,739 16,504 32,060
2009 0 0 15,354 13,417
Female 4.6-Dark Red-Promo 2005 0 0 0 0
2006 39,181 19,069 4,907 69,733
2007 72,762 77,552
2008 54,800 18,352
2009
Female 4-Brown 2005 85,996 52,400 42,809 97,272
2006 19,273 74,654 81,070 25,128
2007 97,143 58,152 5,052
2008 8,149 33,327 38,766 237,430
2009 0 0 97,563 93,917
Female 4-Promo 2005 0 0 0 0
2006 113,977 12,802 1,387 137,945
2007 194,015 245,884
2008 202,987 16,654 0
2009
Female 5.3- Light Golden Brown 2005 33,085 15,680 30,108 43,730
2006 11,367 34,211 22,622 17,105
2007 44,620 24,576 5,584
2008 4,818 10,653 13,407 74,823
2009
Female 5.3- Promo 2005 0 0 0 0
2006 37,911 4,416 936 57,913
2007 85,712 109,373
2008 71,383 11,256 0
2009
Female 5-Dark Brown 2005 39,249 23,852 22,664 35,592
2006 21,246 47,476 16,316 1,281
2007 44,536 23,854 4,188
2008 5,364 14,729 23,015 112,241
2009 0 0 41,813 40,250
Female 5-Promo 2005 0 0 0 0
2006 35,661 7,685 1,548 64,181
2007 103,957 128,747
2008 79,465 15,564 0
2009
Please help.
