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

Another question on Mathematics

Mathematics, 21.06.2019 21:40

Many newspapers carry a certain puzzle in which the reader must unscramble letters to form words. how many ways can the letters of emdangl be arranged? identify the correct unscrambling, then determine the probability of getting that result by randomly selecting one arrangement of the given letters.

Answers: 1

Answer

Mathematics, 21.06.2019 23:30

How do you write 600 as a product of its prime factors (index! )

Answers: 1

Answer

Mathematics, 22.06.2019 00:00

Rewrite the equation x = 65 - 60p by factoring the side that contains the variable p.

Answers: 2

Answer

Mathematics, 22.06.2019 02:30

The product of (7x-2) and (20-3x)/4. when x=4