Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Une Protables to find the number of sales transactions by product and region total amount of revenue by region, and total amount of revenue by

image text in transcribed
Une Protables 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 Click the icon to view the Sales Transactions data X Use Pivot Table to find the number of stes transactions by product and region Type whole numbers Count of Amount East North South West Grand Total Book DVD Grand Total Sales Transactions 0 10009 CustID Region Transaction Code Amount Product 10001 93875386 20 35 DVD 10002 West 74063400 17.94 DVD North 54942368 23. DVD 10004 West 71589015 25.14 Book 10005 South 35208817 1557 Book 10000 West 20970903 17.30 DVD 10007 East 80139155 178.57 Book 10008 West 14132683 22.34 Bock 10000 West 40128225 1592 DVD 10010 South 52801179 24 28 DVD 10011 South 57398827 25.65 Book 10012 East 31400661 20.30 Bock 10013 North 55677290 20.02 DVD 10014 East 62507750 153.44 Bock 10015 West 51555882 21.01 DVD 10018 West 50360546 226 DVD 10017 West 20023353 22.04 Bock 10018 West 78994431 2016 Book 10010 West 2017954 17.45 DVD 10020 West 69868417 18.00 DVD Print Done

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advanced Accounting

Authors: Joe Hoyle, Thomas Schaefer, Timothy Doupnik

10th edition

0-07-794127-6, 978-0-07-79412, 978-0077431808

Students also viewed these Accounting questions