AutoSave C SC EX19_CS8-11a_AlexisDonald_2 - O Search (Alt+Q) Alexis Donald AD ff File Formulas Review View Developer Help Power Pivot PivotTable Analyze Design P Comments A Share Home Insert Page...



  1. Porter 360 is considering whether to raise the price of each product by 10 percent. Add a calculated field to the MaySales PivotTable to show this increase as follows:

    1. Create a calculated field using
      Price
      as its name.

    2. The formula should multiply the
      Payment
      field value by
      1, and then add the result to the
      Payment
      field value to calculate the increased price.




AutoSave C<br>SC EX19_CS8-11a_AlexisDonald_2 -<br>O Search (Alt+Q)<br>Alexis Donald AD<br>ff<br>File<br>Formulas<br>Review<br>View<br>Developer Help<br>Power Pivot<br>PivotTable Analyze<br>Design<br>P Comments<br>A Share<br>Home<br>Insert<br>Page Layout<br>Data<br>Team<br>Pivot Table Name:<br>Active Field:<br>→ Group Selection<br>+E Expand Field<br>MaySales<br>Sum of Payment<br>E Ungroup<br>Refresh Change Data<br>Μove<br>Pivot Table<br>Drill<br>Insert<br>Fields, Items, OLAP Relationships<br>Insert<br>Slicer Timeline Connections<br>Drill<br>Filter<br>Clear Select<br>PivotChart Recommended<br>Field<br>+/-<br>Field<br>IE Options<br>-E Collapse Field<br>Up<br>Pivot Tables<br>List Buttons Headers<br>LE Field Settings Down<br>7 Group Field<br>Source<br>& Sets<br>Tools<br>PivotTable<br>Active Field<br>Group<br>Filter<br>Data<br>Actions<br>Calculations<br>Tools<br>Show<br>C8<br>X V fx<br>219<br>A<br>B<br>D<br>E<br>G<br>H<br>J<br>K<br>L<br>M<br>N<br>P<br>Q<br>R<br>S<br>1<br>PivotTable Fields<br>2<br>Choose fields to add to report:<br>Sum of Payment<br>$747<br>Alarm<br>AL200<br>AL220<br>4<br>Search<br>$518<br>6 Alarm Total<br>$1,265<br>$716<br>$2191<br>$935<br>O Cust ID<br>O Region<br>V Product ID<br>M Product Type<br>7<br>Camera<br>СМ310<br>8<br>CM330<br>Insert Calculated Field<br>?<br>9 Camera Total<br>DB100<br>Modify<br>$2,000<br>$418<br>$2,418<br>$916<br>$249<br>$1,165<br>10<br>Doorbell<br>Name:<br>Price<br>O Order Source<br>V Payment<br>П Рrice<br>11<br>DB120<br>Formula: =|<br>Delete<br>12 Doorbell Total<br>13<br>Floodlight<br>FL110<br>14<br>FL150<br>Fields:<br>More Tables...<br>Cust ID<br>Region<br>Product ID<br>Product Type<br>Order Source<br>Payment<br>Price<br>15 Floodlight Total<br>16 Grand Total<br>$5,783<br>17<br>18<br>19<br>20<br>Insert Figld<br>21<br>22<br>Drag fields between areas below:<br>OK<br>Close<br>23<br>Y Filters<br>I Columns<br>24<br>25<br>26<br>27<br>28<br>29<br>30<br>31<br>32<br>E Rows<br>Σ Values<br>33<br>Product Type<br>Sum of Payment<br>Product ID<br>35<br>36<br>37<br>38<br>39<br>40<br>Sales Comparison<br>May Sales by Region<br>O Defer Layout Update<br>Update<br>Documentation<br>Survey<br>May Sales by Product Type<br>Orders<br>Install ...<br>+)<br>Ready<br>围<br>100%<br>10:00 PM<br>P Type here to search<br>VR<br>38°F Clear<br>12/6/2021<br>15<br>近<br>

Extracted text: AutoSave C SC EX19_CS8-11a_AlexisDonald_2 - O Search (Alt+Q) Alexis Donald AD ff File Formulas Review View Developer Help Power Pivot PivotTable Analyze Design P Comments A Share Home Insert Page Layout Data Team Pivot Table Name: Active Field: → Group Selection +E Expand Field MaySales Sum of Payment E Ungroup Refresh Change Data Μove Pivot Table Drill Insert Fields, Items, OLAP Relationships Insert Slicer Timeline Connections Drill Filter Clear Select PivotChart Recommended Field +/- Field IE Options -E Collapse Field Up Pivot Tables List Buttons Headers LE Field Settings Down 7 Group Field Source & Sets Tools PivotTable Active Field Group Filter Data Actions Calculations Tools Show C8 X V fx 219 A B D E G H J K L M N P Q R S 1 PivotTable Fields 2 Choose fields to add to report: Sum of Payment $747 Alarm AL200 AL220 4 Search $518 6 Alarm Total $1,265 $716 $2191 $935 O Cust ID O Region V Product ID M Product Type 7 Camera СМ310 8 CM330 Insert Calculated Field ? 9 Camera Total DB100 Modify $2,000 $418 $2,418 $916 $249 $1,165 10 Doorbell Name: Price O Order Source V Payment П Рrice 11 DB120 Formula: =| Delete 12 Doorbell Total 13 Floodlight FL110 14 FL150 Fields: More Tables... Cust ID Region Product ID Product Type Order Source Payment Price 15 Floodlight Total 16 Grand Total $5,783 17 18 19 20 Insert Figld 21 22 Drag fields between areas below: OK Close 23 Y Filters I Columns 24 25 26 27 28 29 30 31 32 E Rows Σ Values 33 Product Type Sum of Payment Product ID 35 36 37 38 39 40 Sales Comparison May Sales by Region O Defer Layout Update Update Documentation Survey May Sales by Product Type Orders Install ... +) Ready 围 100% 10:00 PM P Type here to search VR 38°F Clear 12/6/2021 15 近
Jun 09, 2022
SOLUTION.PDF
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here
Have files?