Question: Create PivotTables(please be sure to include it) to find the number of sales transactions by product and region, total amount of revenue by region, and

Create PivotTables(please be sure to include it) to find the number of sales transactions by product and region, total amount of revenue by region, and total amount of revenue by region and product in the Sales Transactions database, and show the formulas being used. Thank you

Loan Purpose Checking Savings Months Customer Months Employed Gender Marital Status Age Housing Years Job Credit Risk
Education $600 $3,500 30 45 M Single 27 Rent 3 Skilled
Business $500 $800 15 20 F Married 26 Rent 1 Unskilled
New Car $250 $250 15 48 M Single 25 Own 3 Skilled
Furniture $101 $3,871 10 16 F Single 26 Own 4 Skilled
Small Appliance $300 $400 10 5 M Divorced 28 Own 2 Skilled
Business $790 $3,000 8 24 M Single 38 Rent 7 Unskilled
Education $680 $600 50 18 F Married 37 Other 6 Management
Retraining $644 $2,000 20 60 M Single 30 Own 4 Skilled
Small Appliance $100 $8,000 12 90 F Single 33 Rent 9 Management
Repairs $0 $900 25 4 M Divorced 29 Own 3 Management

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!