Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

It won't let me put the Pivot Table in Cell A12, I get the errorA PivotTable report cannot overlap a table or XML mapping. The

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

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

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

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... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Managerial Accounting Decision Making and Performance Management

Authors: Ray Proctor

4th edition

273764489, 978-0273764489

More Books

Students also viewed these Programming questions

Question

1.12 Describe the sociocultural perspective on abnormal behavior.

Answered: 1 week ago