Logo
Home Study Material Contact Search
AI Chat FREE
  1. mathematics
  2. basic math
  3. use pivot tables to find the number of sales trans

Use Pivot Tables to find the number of sales transactions by product and region total...

90.2K

Verified Solution

Question

Basic Math

image

Use Pivot Tables 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 accompanying Sales Transact data Click the icon to view the Sales Transactions data Use PivotTables to find the number of sales transactions by product and region Type whole numbers Count of Amount Book DVD Grand Total East North South West Grand Total Sales Transactions Cust ID 10001 10002 Region East West 10003 North 10004 West 10005 South 10006 West 10007 East 10008 West West South 10011 South 10012 East 10013 North 10014 East 10015 West 10016 West 10017 West 10018 West 10009 10010 DVD DVD 24 52 Book 15 61 17 30 179 37 Book DVD Book 22 99 Book Transaction Code Amount Product 93852577 20 43 DVD 74083490 18 07 64942368 23 98 70264827 35208817 20978903 80292759 14132683 40128225 49656996 57398827 34400661 54782609 62597750 51555882 64500628 26623353 78591421 15 92 DVD 24 95 DVD 26 17 Book Book DVD 20 39 20 59 152 49 Book 21 01 23 26 21 81 DVD DVD Book 20 16 Dal 0 X

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Chemistry
1.2K views

The combustion of 0.4196 g of hydrocarbon releases 17.55 kJ of heat. The masses of the...

Physics
1.2K views

Three resistors have values R1= 47Ω, R2 = 100Ω, and R3 = 10 Ω. There is...

Biology
1.2K views

Which is not a measure in prevention and preparedness efforts O Proper storage O Good...

Biology
1.2K views

Public Opinion Polls Campaign Advertising Special Interest

Basic Math
1.2K views

The sizes of two matrices A and B are given Find the sizes of the...

Basic Math
1.2K views

Online courses: A sample of 261 students who were taking online courses were asked to...

Basic Math
1.2K views

For y = -9 cos x/7,its amplitude isits period is

Statistics
1.2K views

A group of engineers developed a new design for a steel cable They need to...

Algebra
1.2K views

Which of the following sequences is an arithmetic sequence O 3 4 6 9 13...

Accounting
1.2K views

All Natural processes organic milk into plain yogurt. All Natural sells plain yogurt to hospitals,...

Accounting
1.2K views

May with withdrew $500000 from her personal savings and deposited into the business account and...

Accounting
1.2K views

Based on a predicted level of production and sales of 21,000 units, a company anticipates...