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
Get step-by-step solutions from verified subject matter experts
