pivot table.xlsx - Month January Store east north south...

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

View Full Document Right Arrow Icon
Data Month Store Sum - Revenue Sum - Units January 175277.83 58435 east 40619.81 12702 north 32484.68 10146 south 47471.53 15818 west 54701.81 19769 February 180531.11 60823 east 40387.5 14539 north 33659.07 12134 south 57397.13 18731 west 49087.41 15419 March 196650.82 65029 east 50586.87 15929 north 47430.14 15428 south 51265.19 17271 west 47368.62 16401 April 172387.79 56328 east 41610.22 14222 north 43953.22 13753 south 39829.67 13216 west 46994.68 15137 May 160366.14 56548 east 34558.43 12423 north 22291.72 7780 south 65945.34 22630 west 37570.65 13715 June 171870.14 57784 east 24559.97 8464 north 53671.92 18026 south 45741.95 15570 west 47896.3 15724 July 170265.62 58153 east 29690.7 10637 north 39530.96 13702 south 63350.23 21229 west 37693.73 12585 August 157296.48 53683 east 36126.4 12163 north 36971.6 12644 south 41817.51 13092 west 42380.97 15784 September 182057.92 60610 east 49947.66 16464 north 40780.2 13328 south 51137.16 17259 west 40192.9 13559 October 163888.83 54572 east 42472.84 14738 north 52469.76 16039 south 28746.76 10082
Image of page 1

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

View Full Document Right Arrow Icon
west 40199.47 13713 November 170746.27 56518 east 43883.39 14143 north 30919.14 10469 south 49129.62 15681 west 46814.12 16225 December 166995.4 54644 east 41370.44 13164 north 40270.64 12844 south 33814.62 11576 west 51539.7 17060 Total Result 2068334.35 693127
Image of page 2
Year Month Store Group Product Units Revenue 2007 August south milk low fat 805 3187.80 2007 March south ice cream Edies 992 3412.48 2007 January east milk skim 712 1808.48 2006 March north ice cream Edies 904 2260.00 2006 January south ice cream Edies 647 2076.87 2005 Septemberwest fruit plums 739 1707.09 2006 March east milk low fat 974 2181.76 2007 June north fruit apples 615 1894.20 2007 July west fruit cherries 714 1856.40 2006 May south cereal Special K 703 1553.63 2005 June west ice cream Edies 528 2064.48 2006 October east cereal Raisin Bran 644 1809.64 2005 June south fruit grapes 919 2196.41 2007 May west milk skim 767 1932.84 2007 June west cereal Raisin Bran 984 1987.68 2005 March south cereal Raisin Bran 744 2217.12 2007 Septembereast ice cream Edies 693 2189.88 2006 October east milk chocolate 658 1895.04 2005 Novembereast ice cream Breyers 878 3274.94 2005 May south ice cream Breyers 848 3281.76 2007 August south milk low fat 547 1247.16 2005 June west ice cream Edies 664 1513.92 2007 April south ice cream Edies 882 2716.56 2007 February west fruit plums 930 2408.70 2005 Novembereast cereal Special K 735 2594.55 2007 July north ice cream Edies 557 1542.89 2007 July west ice cream Breyers 790 2456.90 2007 August south ice cream Breyers 730 2664.50 2006 December south fruit plums 815 2901.40 2005 August west fruit plums 727 2006.52 2006 October north cereal Cheerios 644 1713.04 2006 January south cereal Raisin Bran 939 2319.33 2005 June north cereal Raisin Bran 739 1544.51 2006 July north cereal Raisin Bran 866 2866.46 2006 January south fruit grapes 513 1395.36 2007 July west ice cream Edies 534 1244.22 2007 Septembereast cereal Cheerios 587 1590.77 2007 October west fruit apples 770 1817.20 2006 March north milk low fat 536 1972.48 2005 Septembereast fruit grapes 787 1967.50 2005 January west cereal Special K 687 2397.63 2005 August west milk low fat 687 1449.57 2007 March west cereal Special K 943 1886.00 2006 May south milk low fat 731 2485.40 2007 October east fruit apples 993 3227.25 2007 March west fruit plums 686 1996.26
Image of page 3

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

View Full Document Right Arrow Icon
2005 March south fruit apples 675 2457.00 2005 May east milk chocolate 598 1477.06 2006 February south cereal Raisin Bran 604 1963.00 2006 February south ice cream Breyers 693 1517.67 2006 February north milk skim 766 1646.90 2007 April west cereal Special K 509 1812.04 2005 April south fruit cherries 901 2234.48 2006 June east cereal Special K 625 1368.75 2007 May east milk whole 914 3518.90 2006 March east cereal Cheerios 768 2027.52 2005 April west fruit apples 681 1695.69 2007 August west ice cream Ben and Je 630 2186.10 2007 January north fruit plums 704 2471.04 2006 March north fruit cherries 806 1781.26 2006 April west fruit plums 673 2591.05 2007 May west milk low fat 920 3293.60 2007 October west ice cream Edies 651 2180.85 2005 June west cereal Raisin Bran 775 1860.00 2007 May south cereal Special K 583 1953.05 2006 December east cereal Cheerios 542 2059.60 2005 May east cereal Raisin Bran 952 3303.44 2005 January east milk chocolate 618 2329.86 2005 August west milk chocolate 573 1839.33 2005 August east cereal
Image of page 4
Image of page 5
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