Mathematics, 25.02.2020 16:33 cooper2017

Use PivotTables 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 Transactions data.

Use PivotTables to find the number of sales transactions by product and region.

Cust ID Region Transaction Code Amount Product
10001 East 94361225 20.37 DVD
10002 West 74083490 18.11 DVD
10003 North 64942368 23.98 DVD
10004 West 70385587 23.81 Book
10005 South 35208817 15.82 Book
10006 West 20978903 17.30 DVD
10007 East 80161506 179.89 Book
10008 West 14132683 21.92 Book
10009 West 40128225 15.92 DVD
10010 South 51357358 24.29 DVD
10011 South 57398827 25.79 Book
10012 East 34400661 20.39 Book
10013 North 55124884 20.81 DVD
10014 East 62597750 153.27 Book
10015 west 51555882 21.01 DVD
10016 West 56999364 23.23 DVD
10017 West 26623353 20.98 Book
10018 West 78594431 20.16 Book
10019 West 92881032 17.66 DVD
10020 West 69868417 17.89 DVD

Answers: 2

Show answers

Other questions on the subject: Mathematics

Mathematics, 21.06.2019 19:50, jlankford148

A3-dimensional figure has a square base and 4 lateral faces that meet at a point. explain the difference between the cross sections when a slice is made perpendicular to the base through the vertex, and when a slice is made perpendicular to the base and not through the vertex

Answers: 2

continue

Mathematics, 21.06.2019 20:30, gamelaza431

At the "no mutants allowed" country farm, every sheep has 4 legs, every chicken has two legs, and all animals have only 1 head. asked to count how many sheep and chicken are in the fields, a farm boy reports back that there are 140 feet and 50 heads. how many sheep and chicken are there? there are sheep and chicken at the farm.

Answers: 1

continue

Mathematics, 21.06.2019 20:30, shan6171

Acircle has a circumference of 7.850 units. what is its radius?

Answers: 2

continue

Mathematics, 21.06.2019 22:20, sethlynn2003

Question 5 of 10 2 points if a population is a sample of the population could be a. registered voters; all citizens o o b. baptists; all religious people o c. people who purchased shoes; all customers o d. the entire school faculty; math teachers

Answers: 3

continue

You know the right answer?

Use PivotTables to find the number of sales transactions by product and region, total amount of reve...