It won't let me put the Pivot Table in Cell A12, I get the error"A PivotTable report cannot overlap a table or XML mapping. The full table range is A15:J212

On the Sales worksheet, using the rangeA15:J212, insert a PivotTable in cell A12 on theSalesAnalysis worksheet.	8
Configure the PivotTable using the following. Add Units, Staff, and Staff Category to the PivotTable. Move Staff Category to the COLUMNS area. Using the Column Labels arrow, uncheck Manager. Right-click cell E14, point to Sort, and then sort the data inascending order.	4

Transcribed Image Text:

File 1 Date 2 3 4 5 6 7 8 Pivot Table Recommended Table Pictures Pivot Tables Tables 9 10 11 12 13 14 Home Insert Page Layout 15 Date 16 5/1/2018 17 5/1/2018 18 5/1/2018 19 5/1/2018 20 5/1/2018 21 5/1/2018 22 5/1/2018 23 5/1/2018 24 5/2/2018 25 5/2/2018 26 5/2/2018 27 5/2/2018 28 5/2/2018 29 5/2/2018 Ready 44 HH Units Product Units Formulas Data Online Pictures L Shapes Icons Sales с Product 1 Spaaaaah - Hair Wrap 2 Sandalwood Massage Oil 2 Vanilla Bean Massage Oil Illustrations 2 Water - rejuvenating, flavored, 12 oz bottle 2 Geranium Rose Bath Crystals 1 Vanilla Bean reed oil 1 Vanilla Bean Massage Oil 1 Nail repair 2 Nail repair 4 Geranium Rose Bath Crystals 1 Nail repair 1 Sandalwood reed oil 1 Vanilla Bean reed oil 3 Healthy Hands - extra dry Sheet4 Filter SalesAnalysis Review 3D Models ▾ SmartArt Screenshot- D Category View Help SalesBackup Get Add-ins My Add-ins Category Clothing Massage Oil Massage Oil Food Skincare Scents Massage Oil Hand Care Hand Care Skincare Hand Care Scents Scents Hand Care + Search FA Bing People Maps Graph Add-ins F Retail_Price Staff Retail_Price Staff 17.95 Kendra 19.95 Kelly 19.95 Kelly 4.19 Pat 6.99 Kendra 6.95 Irene 19.95 Kendra 9.95 Jason 9.95 Christy 6.99 Susan 9.95 Jason 6.95 Jason 6.95 Pat 8.5 Christy Recommended Charts G D-BA -- Staff_Category Receptionist Charts Transaction count Units sold Subtotal sum Retail average H Hotel Guest $ Ś Staff_Category Massage Therapist Yes Receptionist Receptionist Yes On Maps PivotChart No Massage Therapist No No Massage Therapist Yes Manager Massage Therapist Yes Massage Therapist Massage Therapist Nail Technician Massage Therapist Nail Technician Massage Therapist Yes Yes No Yes Yes Yes Massage Therapist Yes 197 283 2,074.32 10.53 Hotel_Guest I Trans_Type Card 3D Map Tours card card cash card cash check cash card card cash check M. Line Column Win/ Loss Trans_Type Subtot cash check check J Sparklines 17.95 39.90 39.90 8.38 13.98 6.95 19.95 9.95 19.90 27.96 9.95 6.95 6.95 25.50 K L Microsoft Excel 4 10: Slicer Timeline Filters 5 M Link Links N Comment Comments O P A Text Header Box & Footer Object A PivotTable report cannot overlap a table or XML mapping. A WordArt Signature Line + O Text R S 间 LO Share π Equation Symbol T Symbols U Comments V 100% V File 1 Date 2 3 4 5 6 7 8 Pivot Table Recommended Table Pictures Pivot Tables Tables 9 10 11 12 13 14 Home Insert Page Layout 15 Date 16 5/1/2018 17 5/1/2018 18 5/1/2018 19 5/1/2018 20 5/1/2018 21 5/1/2018 22 5/1/2018 23 5/1/2018 24 5/2/2018 25 5/2/2018 26 5/2/2018 27 5/2/2018 28 5/2/2018 29 5/2/2018 Ready 44 HH Units Product Units Formulas Data Online Pictures L Shapes Icons Sales с Product 1 Spaaaaah - Hair Wrap 2 Sandalwood Massage Oil 2 Vanilla Bean Massage Oil Illustrations 2 Water - rejuvenating, flavored, 12 oz bottle 2 Geranium Rose Bath Crystals 1 Vanilla Bean reed oil 1 Vanilla Bean Massage Oil 1 Nail repair 2 Nail repair 4 Geranium Rose Bath Crystals 1 Nail repair 1 Sandalwood reed oil 1 Vanilla Bean reed oil 3 Healthy Hands - extra dry Sheet4 Filter SalesAnalysis Review 3D Models ▾ SmartArt Screenshot- D Category View Help SalesBackup Get Add-ins My Add-ins Category Clothing Massage Oil Massage Oil Food Skincare Scents Massage Oil Hand Care Hand Care Skincare Hand Care Scents Scents Hand Care + Search FA Bing People Maps Graph Add-ins F Retail_Price Staff Retail_Price Staff 17.95 Kendra 19.95 Kelly 19.95 Kelly 4.19 Pat 6.99 Kendra 6.95 Irene 19.95 Kendra 9.95 Jason 9.95 Christy 6.99 Susan 9.95 Jason 6.95 Jason 6.95 Pat 8.5 Christy Recommended Charts G D-BA -- Staff_Category Receptionist Charts Transaction count Units sold Subtotal sum Retail average H Hotel Guest $ Ś Staff_Category Massage Therapist Yes Receptionist Receptionist Yes On Maps PivotChart No Massage Therapist No No Massage Therapist Yes Manager Massage Therapist Yes Massage Therapist Massage Therapist Nail Technician Massage Therapist Nail Technician Massage Therapist Yes Yes No Yes Yes Yes Massage Therapist Yes 197 283 2,074.32 10.53 Hotel_Guest I Trans_Type Card 3D Map Tours card card cash card cash check cash card card cash check M. Line Column Win/ Loss Trans_Type Subtot cash check check J Sparklines 17.95 39.90 39.90 8.38 13.98 6.95 19.95 9.95 19.90 27.96 9.95 6.95 6.95 25.50 K L Microsoft Excel 4 10: Slicer Timeline Filters 5 M Link Links N Comment Comments O P A Text Header Box & Footer Object A PivotTable report cannot overlap a table or XML mapping. A WordArt Signature Line + O Text R S 间 LO Share π Equation Symbol T Symbols U Comments V 100% V

Answer rating: 100% (QA)

Step 1 Solution The error message youre encountering A PivotTable report cannot overlap a table or XML mapping suggests that there might be an existing table or XML mapping in the range where youre tr... View the full answer