Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

if you dont know how to solve it , please let someone who does solve it . thank you in advance 1 Your goal is

if you dont know how to solve it , please let someone who does solve it . thank you in advance image text in transcribed
1 Your goal is to use the Relationship Feature to connect these two tables and then make a Pivot Table that shows the Units by Region 2 A picture of the Final Pivot Table can be seen to the right When you create the Relationship, use the "Sales RepName" Column 4 5 6 7 Region East West Grand Total Sum of Units 787 646 1,433 9 Units 50 10 11 12 13 14 15 16 17 Sales Rep Name Sioux TY Chantel Mill Region East West East West 19 20 21 Date Sales Rep Name 8/3/2019 Chantel &/16/2019TY BA 2011 TY 8/6/2019 Slow 8/6/2019 Miki 2/1/2019 8/20/2019 M 8/18/2019 Sioux 8/7/2019 8/21/2019 MIN 8/22/2019TY B/13/2019 MM B/13/2019 TY 8/20/2010 Slow 1/14/2019 Slow 8/20/2019 MAI B/5/2019 Sious W/23/2013 Chanel W11/2010 3/6/2019 y B/1/2019 8/21/2010 8/20/2019 Chanel 76 3 10 77 23 240 25 26 27 28 29 30 114 64 104 42 22 82 39 81 12 98 131 11 32 33 35 30 37

Step by Step Solution

There are 3 Steps involved in it

Step: 1

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

An Introduction To Financial Markets A Quantitative Approach

Authors: Paolo Brandimarte

1st Edition

1118014774, 9781118014776

More Books

Students also viewed these Finance questions

Question

How do you explain your dataset?

Answered: 1 week ago