CompExcel_Pivot_Table_Project_Data

CompExcel_Pivot_Table_Project_Data - Product Type (All) Sum...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
Product Type (All) Sum of Sale Amount Store City Total Nashua 144848 Salem 175606 Woburn 241148 Grand Total 561602
Background image of page 1

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

View Full DocumentRight Arrow Icon
Sum of Sale Amount Sale Date Store City Product Type Jan Feb Mar Apr May Jun Grand Total Woburn Desktop 5303 4743 5013 4375 6002 5403 30839 Inkjet Printer 1692 1732 1413 1413 1791 1851 9892 Laserjet Printer 499 499 599 599 499 499 3194 Notebook 4156 5045 5934 6074 8981 9850 40040 Premium Desktop 13132 14721 14741 11863 15361 15101 84919 Premium Notebook 7956 9755 10255 12294 11914 20090 72264 Woburn Total 32738 36495 37955 36618 44548 52794 241148 Grand Total 32738 36495 37955 36618 44548 52794 241148
Background image of page 2
Sale Date Product Type 1 3 Nashua NH cjm 1-Jan-20 9 1 Hewlet -Packard 3 Desktop $649 2 1 Woburn MA emm 1-Jan-20 9 7 Lexmark 5 Inkjet Printer $239 2 1 Woburn MA emm 1-Jan-20 9 7 Lexmark 5 Inkjet Printer $239 3 1 Woburn MA jse 1-Jan-20 9 2 Compaq 3 Desktop $69 4 2 Salem NH js 1-Jan-20 9 1 Hewlet -Packard 3 Desktop $649 5 1 Woburn MA mmm 1-Jan-20 9 1 Hewlet -Packard 5 Inkjet Printer $19 6 2 Salem NH cew 2-Jan-20 9 3 Sony 1 Notebo k $989 7 3 Nashua NH cjm 2-Jan-20 9 1 Hewlet -Packard 5 Inkjet Printer $19 7 3 Nashua NH cjm 2-Jan-20 9 3 Sony 4 Premium Desktop $1,749 8 3 Nashua NH lok 2-Jan-20 9 3 Sony 3 Desktop $869 8 3 Nashua NH lok 2-Jan-20 9 1 Hewlet -Packard 4 Premium Desktop $1,569 9 1 Woburn MA emm 3-Jan-20 9 2 Compaq 4 Premium Desktop $1,649 10 1 Woburn MA jse 3-Jan-20 9 1 Hewlet -Packard 4 Premium Desktop $1,569 1 1 Woburn MA mmm 3-Jan-20 9 7 Lexmark 5 Inkjet Printer $239 1 1 Woburn MA mmm 3-Jan-20 9 6 Epson 6 Laserjet Printer $49 12 2 Salem NH mtw 3-Jan-20 9 1 Hewlet -Packard 4 Premium Desktop $1,569 12 2 Salem NH mtw 3-Jan-20 9 2 Compaq 2 Premium Notebo k $1,89 13 3 Nashua NH mwm 3-Jan-20 9 1 Hewlet -Packard 3 Desktop $649 13 3 Nashua NH mwm 3-Jan-20 9 1 Hewlet -Packard 1 Notebo k $1,049 14 2 Salem NH tjs 3-Jan-20 9 1 Hewlet -Packard 1 Notebo k $1,049 15 2 Salem NH cew 4-Jan-20 9 1 Hewlet -Packard 5 Inkjet Printer $19 16 3 Nashua NH lok 4-Jan-20 9 3 Sony 2 Premium Notebo k $2,09 17 2 Salem NH cew 5-Jan-20 9 1 Hewlet -Packard 1 Notebo k $1,049 18 2 Salem NH js 5-Jan-20 9 1 Hewlet -Packard 5 Inkjet Printer $19 19 1 Woburn MA maj 5-Jan-20 9 3 Sony 2 Premium Notebo k $2,09 20 1 Woburn MA mmm 5-Jan-20 9 5 IBM 4 Premium Desktop $1,749 21 3 Nashua NH mwm 5-Jan-20 9 1 Hewlet -Packard 5 Inkjet Printer $19 2 1 Woburn MA jse 6-Jan-20 9 1 Hewlet -Packard 1 Notebo k $1,049 23 2 Salem NH js 6-Jan-20 9 3 Sony 3 Desktop $869 24 3 Nashua NH lok 6-Jan-20 9 6 Epson 5 Inkjet Printer $179 24 3 Nashua NH lok 6-Jan-20 9 2 Compaq 2 Premium Notebo k $1,89 25 1 Woburn MA mmm 6-Jan-20 9 1 Hewlet -Packard 1 Notebo k $1,049 26 2 Salem NH js 7-Jan-20 9 1 Hewlet -Packard 5 Inkjet Printer $19 27 3 Nashua NH lok 7-Jan-20 9 3 Sony 2 Premium Notebo k $2,09 28 3 Nashua NH mwm 7-Jan-20 9 1 Hewlet -Packard 1 Notebo k $1,049 29 2 Salem NH js 9-Jan-20 9 7 Lexmark 6 Laserjet Printer $59 30 2 Salem NH tjs # # 3 Sony 1 Notebo k $989 31 1 Woburn MA jse # # 2 Compaq 3 Desktop
Background image of page 3

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

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

This document was uploaded on 11/01/2011 for the course I SYS 201 at BYU.

Page1 / 9

CompExcel_Pivot_Table_Project_Data - Product Type (All) Sum...

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

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