Home

SCENARIO PIVOT TABLE

%3CLINGO-SUB%20id%3D%22lingo-sub-740623%22%20slang%3D%22en-US%22%3ESCENARIO%20PIVOT%20TABLE%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-740623%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone%2C%20I%20am%20really%20having%20difficulty%20understanding%20what%20the%20following%20steps%20are%20sking%20me%20to%20do.%20The%20current%20chart%20I%20have%20is%20not%20what%20I%20am%20supposed%20to%20be%20getting.%20Any%20help%20is%20appreciated%20please!%20Thank%20you!!%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESwitch%20back%20to%20the%3CEM%3E%20All%20Products%3C%2FEM%3E%20Use%20the%20Scenario%20Manager%20as%20follows%20to%20compare%20the%20profit%20per%20unit%20in%20each%20scenario%3A%3C%2FP%3E%3COL%3E%3CLI%3ECreate%20a%20Scenario%20PivotTable%20report%20for%20result%20cells%20%3CSTRONG%3EB17%3AD17%3C%2FSTRONG%3E.%3C%2FLI%3E%3CLI%3ERemove%20the%20Filter%20field%20from%20the%20PivotTable.%3C%2FLI%3E%3CLI%3EChange%20the%20number%20format%20of%20the%20%3CSTRONG%3EProfit_per_Unit_Sold_Single_Cup%3C%2FSTRONG%3E%2C%3CSTRONG%3E%20Profit_per_Unit_Sold_Auto_Drip%3C%2FSTRONG%3E%2C%20and%3CSTRONG%3E%20Profit_per_Unit_Sold_French_Pre%20%3C%2FSTRONG%3Efields%20(located%20in%20the%20Values%20box%20of%20the%20PivotTable%20Field%20List)%20to%20%3CSTRONG%3ECurrency%20%3C%2FSTRONG%3Ewith%20%3CSTRONG%3E2%3C%2FSTRONG%3E%20decimal%20places%20and%20%3CSTRONG%3E%24%3C%2FSTRONG%3E%20as%20the%20symbol.%3C%2FLI%3E%3CLI%3EUse%20%3CSTRONG%3ESingle%20Cup%3C%2FSTRONG%3E%20as%20the%20row%20label%20value%20in%20cell%20B3%2C%20%3CSTRONG%3EAuto%20Drip%3C%2FSTRONG%3E%20as%20the%20value%20in%20cell%20C3%2C%20and%20%3CSTRONG%3EFrench%20Press%3C%2FSTRONG%3E%20as%20the%20value%20in%20cell%20D3.%3C%2FLI%3E%3CLI%3EIn%20cell%20A1%2C%20use%20%3CSTRONG%3EProfit%20per%20Unit%20Sold%20%3C%2FSTRONG%3Eas%20the%20report%20title.%3C%2FLI%3E%3CLI%3EFormat%20the%20report%20title%20using%20the%20%3CSTRONG%3ETitle%20%3C%2FSTRONG%3Ecell%20style.%3C%2FLI%3E%3CLI%3EResize%20column%20A%20using%20AutoFit.%20Resize%20columns%20B-D%20to%20%3CSTRONG%3E00%3C%2FSTRONG%3E.%3C%2FLI%3E%3C%2FOL%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-740623%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPivotTable%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
ElsaRobles
New Contributor

Hi everyone, I am really having difficulty understanding what the following steps are sking me to do. The current chart I have is not what I am supposed to be getting. Any help is appreciated please! Thank you!! 

 

Switch back to the All Products Use the Scenario Manager as follows to compare the profit per unit in each scenario:

  1. Create a Scenario PivotTable report for result cells B17:D17.
  2. Remove the Filter field from the PivotTable.
  3. Change the number format of the Profit_per_Unit_Sold_Single_Cup, Profit_per_Unit_Sold_Auto_Drip, and Profit_per_Unit_Sold_French_Pre fields (located in the Values box of the PivotTable Field List) to Currency with 2 decimal places and $ as the symbol.
  4. Use Single Cup as the row label value in cell B3, Auto Drip as the value in cell C3, and French Press as the value in cell D3.
  5. In cell A1, use Profit per Unit Sold as the report title.
  6. Format the report title using the Title cell style.
  7. Resize column A using AutoFit. Resize columns B-D to 00.