Pivot1 - Sum of Sales State Type NSW Red White NSW Total SA Red White SA Total Vic Red White Vic Total WA Red White WA Total Grand Total Month

Info iconThis 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
Background image of page 1

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

View Full DocumentRight 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 Semil on Tyr el's Vat 1 282.00 138.18 12 3384 Huon Hooke NSW Dec-97 Red Shiraz Wynns Coonawar a 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 Rymil Shiraz 130.50 65.25 9 1174.5 Huon Hooke NSW Dec-97 Red Shiraz Wynns Coonawar a Hermitage 132.00 58.08 12 1584 Huon Hooke NSW Dec-97 Red Melot Shot esbrooke Merlot 90.00 36.00 5 450 Huon Hooke NSW Dec-97 White
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 01/19/2012 for the course GEOL 123 taught by Professor Kim during the Winter '11 term at Bowling Green.

Page1 / 2

Pivot1 - Sum of Sales State Type NSW Red White NSW Total SA Red White SA Total Vic Red White Vic Total WA Red White WA Total Grand Total Month

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online