In the Pivot Table exercise, the question to answer is to make a table that shows the "Promotional effect on sales for each product". What are the Pivot Table Fields that need to be used and what needs to be put in the Filters, Rows, Columns, and/or Values?

Copy of BakeryData 1 - Excel jennifer lewis JL X AutoSave . Off) File Home Insert Page Layout Formulas Data Review View Help Search Share Comments AutoSum Calibri - 11 AA ab Wrap Text General Fill AY O Conditional Format as Cell Insert Delete Format Sort & Find & Ideas Paste BIU . C - A Merge & Center . $ - % " Formatting Table * Styles Clear Filter * Select Clipboard G Font Alignment Number Styles Cells Editing Ideas 019 X V A B C D E F G H J K L M N O P Q R S T daywk weekday Date Cakes Pies Cookies Smoothie Coffee promotion Tuesday 2 1/1/2013 79 46 518 60 233 none 1 Monday Wednesd 3 1/2/2013 91 50 539 161 427 none 2 Tuesday Thursday 4 1/3/2013 47 60 222 166 347 none 3 Wednesday Friday 5 1/4/2013 89 64 734 153 358 none LD 00 01 4 Thursday Saturday 6 1/5/2013 112 73 764 240 392 none 5 Friday Sunday 7 1/6/2013 89 57 922 259 510 none 6 Saturday Monday 1/7/2013 70 50 476 120 334 none 1) Promotional effect on sales for each product 7 Sunday Tuesday 2 1/8/2013 70 48 496 222 316 none 10 Wednesd 3 1/9/2013 59 37 587 181 156 none 2) Daily Breakdown of sales for each product (Monday, T 11 Thursday 4 1/10/2013 71 36 488 178 298 none 12 Friday 5 1/11/2013 74 50 645 100 490 none 3) Monthly breakdown of sales for each product (January 13 Saturday 6 1/12/2013 119 71 438 162 416 none 14 Sunday 7 1/13/2013 90 51 568 137 434 none 15 Monday 1 1/14/2013 96 48 585 194 573 promotion 16 Tuesday 2 1/15/2013 62 56 536 112 287 none 17 Wednesd 3 1/16/2013 48 33 336 151 420 none 18 Thursday 4 1/17/2013 58 67 404 166 376 none 19 Friday 5 1/18/2013 74 74 533 181 456 none 20 Saturday 6 1/19/2013 94 45 470 208 584 none 21 Sunday 7 1/20/2013 97 54 395 231 411 none 22 Monday 1 1/21/2013 79 36 431 159 308 none Tunedou 1/29/2012 20 276 207 mona Data Promotional Affect Daily Breakdown Monthly Breakdown (+ Q J -- + 100% Ready 2:23 PM Type here to search O em 5/16/2020