{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

pivot1 - Sum of Sales State Type NSW Red White NSW Total SA...

Info icon This preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Sum of Sales Month State Type Jan-97 Feb-97 Mar-97 Apr-97 May-97 Jun-97 Jul-97 Aug-97 Sep-97 Oct-97 Nov-97 Dec-97 Grand Total NSW Red 606 342 342 528 466.5 750 685.2 1083.4 993 252 786.2 616.5 7450.8 White 650.8 809.4 674.4 454.6 461.5 809.4 365.4 135 130.5 650.8 377 306.9 5825.7 NSW Total 1256.8 1151.4 1016.4 982.6 928 1559.4 1050.6 1218.4 1123.5 902.8 1163.2 923.4 13276.5 SA Red 592.5 648 648 799.2 913 649 910.5 1343.2 861 1102.2 1305.7 1547 11319.3 White 257.4 417 365.05 813.4 863.8 777.8 696.05 555.5 396 769.5 709 388.5 7009 SA Total 849.9 1065 1013.05 1612.6 1776.8 1426.8 1606.55 1898.7 1257 1871.7 2014.7 1935.5 18328.3 Vic Red 1166.4 447 443.5 568.2 1049.4 720 364.5 462 444 399 628.5 642 7334.5 White 386.4 258 160 135 275.5 257.4 634.4 489.4 430 773.8 342 602.4 4744.3 Vic Total 1552.8 705 603.5 703.2 1324.9 977.4 998.9 951.4 874 1172.8 970.5 1244.4 12078.8 WA Red 591 906 1497 White 367 403 770 WA Total 958 1309 2267 Grand Total 3659.5 2921.4 2632.95 4256.4 4029.7 3963.6 3656.05 4068.5 3254.5 3947.3 5457.4 4103.3 45950.6 Sum of Product Month State Type Jan-97 Feb-97 Mar-97 Apr-97 May-97 Jun-97 Jul-97 Aug-97 Sep-97 Oct-97 Nov-97 Dec-97 Grand Total NSW Red 3924 2538 2538 5616 5206.5 5580 8222.4 12614.8 10758 1098 7507.4 6376.5 71979.6 White 7114.6 8470.8 7255.8 4236.4 4856.5 8470.8 3288.6 1215 1174.5 7114.6 3482 2546.1 59225.7 NSW Total 11038.6 11008.8 9793.8 9852.4 10063 14050.8 11511 13829.8 11932.5 8212.6 10989.4 8922.6 131205.3 SA Red 4408.5 5112 6336 7808.4 9418 6142 10534.5 13113.4 9174 11351.4 12673.9 14369 110441.1 White 2656.8 4599 3430.45 7820.8 8830.6 6858.2 7112.45 5289.5 3564 7481.7 8218 3838.5 69700 SA Total 7065.3 9711 9766.45 15629.2 18248.6 13000.2 17646.95 18402.9 12738 18833.1 20891.9 18207.5 180141.1 Vic Red 13996.8 4209 3824.5 5663.4 11434.8 5466 3280.5 3234 4464 2931 4666.5 6552 69722.5 White 4323.6 2664 1600 1215 2624.5 2656.8 6138.8 4688.8 4030 8563.6 2862 6823.8 48190.9 Vic Total 18320.4 6873 5424.5 6878.4 14059.3 8122.8 9419.3 7922.8 8494 11494.6 7528.5 13375.8 117913.4 WA Red 3999 10152 14151 White 3247 4114 7361 WA Total 7246 14266 21512 Grand Total 36424.3 27592.8 24984.75 39606 42370.9 35173.8 38577.25 40155.5 33164.5 38540.3 53675.8 40505.9 450771.8
Image of page 1

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
01/19/2012 23:05:11 e80f6404ea3898d441205995eb97352808dfe1a3.xls Page 2 of 2 Rep State Month Type Group Part Sales Margin Quantity Product Roland Wahlquist Vic Dec-97 White Riesling Heggies Riesling 185.40 101.97 12 2224.8 Roland Wahlquist Vic Nov-97 Red Melot Cassegrain Merlot 54.00 25.92 4 216 Roland Wahlquist Vic Jan-97 White Semillon Tyrrel's Vat 1 282.00 138.18 12 3384 Huon Hooke NSW Dec-97 Red Shiraz Wynns Coonawarra Hermitage 132.00 58.08 12 1584 Huon Hooke NSW Dec-97 White Riesling Houghton Rhine Riesilng 104.40 40.72 9 939.6 Huon Hooke NSW Dec-97 Red Shiraz Rymill Shiraz 130.50 65.25 9 1174.5 Huon Hooke NSW Dec-97 Red Shiraz Wynns Coonawarra Hermitage 132.00 58.08 12 1584 Huon Hooke NSW Dec-97 Red Melot Shottesbrooke Merlot 90.00 36.00 5 450 Huon Hooke NSW Dec-97 White Riesling Grosset Polish Hill 130.50 58.73 9 1174.5 Huon Hooke NSW Dec-97 Red Shiraz Wynns Coonawarra Hermitage 132.00 52.80 12 1584 Huon Hooke NSW Dec-97 White Riesling Grant Burge Riesling 72.00 32.40 6 432 Geg Clayfield SA Dec-97 Red Melot Cassegrain Merlot 54.00 25.92 4 216 Peter Douglas SA Dec-97 Red Pinot Noir Mountadam Pinot Noir 234.00 128.70 9 2106 Peter Douglas SA Dec-97 Red Melot Cassegrain Merlot 54.00 21.06 4 216 Geg Clayfield SA Dec-97 White Riesling Grosset Polish Hill 130.50 58.73 9 1174.5 Peter Douglas SA Dec-97 Red Pinot Noir Mountadam Pinot Noir 234.00 114.66 9 2106 Peter Douglas SA Dec-97 Red Shiraz Mount Hurtle Shiraz 138.00 67.62 12 1656 Geg Clayfield SA Dec-97 White Riesling Henschke Julius 186.00 102.30 12 2232 Peter Douglas SA Dec-97 Red Pinot Noir Heggies Pinot Noir 193.00 73.34 10 1930 Peter Douglas SA Dec-97 Red Blend Blue Pyrenees Estate 282.00 149.46 12 3384 Geg Clayfield SA Dec-97 Red Pinot Noir Heggies Pinot Noir 193.00 75.27 10 1930 Peter Douglas SA Dec-97 White Riesling Grant Burge Riesling 72.00 33.12 6 432 Peter Douglas SA Dec-97 Red Blend Henshke Mt Edelstone 165.00 77.55 5 825 Ian McKenzie Vic Dec-97 Red Blend Stonyfell Metala 168.00 77.28 12 2016 Mark Shield Vic Dec-97 Red Shiraz Wynns Coonawarra Hermitage 132.00 58.08 12 1584 Roland Wahlquist Vic Dec-97 Red Blend Stonyfell Metala 168.00 62.16 12 2016 Roland Wahlquist Vic Dec-97 Red Pinot Noir Smithbrook Pinot Noir 120.00 48.00 6 720 Roland Wahlquist Vic Dec-97 Red Melot Cassegrain Merlot 54.00 24.30 4 216 Roland Wahlquist Vic Dec-97 White Semillon Tyrrel's Vat 1 282.00 138.18 12 3384 Roland Wahlquist Vic Dec-97 White
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern