Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Use pivot tables to find the number of sales transactions by product and region, the total amount of revenue by region, and the total amount

Use pivot tables to find the number of sales transactions by product and region, the total amount of revenue by region, and the total amount of revenue by region and product in the accompanying sales transaction data.

Client ID

Region

Transaction code

Amount

Product

10001

It is

94229674

20.46

DVD

10002

West

74083490

18.09

DVD

10003

Norte

64942368

23.98

DVD

10004

West

71769545

24.75

Book

10005

On

35208817

15.42

Book

10006

West

20978903

17.30

DVD

10007

It is

80167293

178.37

Book

10008

West

14132683

22.56

Book

10009

West

40128225

15.92

DVD

10010

On

52719590

23.89

DVD

10011

On

57398827

24.46

Book

10012

It is

34400661

20.39

Book

10013

Norte

56005132

22.06

DVD

10014

It is

62597750

153.38

Book

10015

West

51555882

21.01

DVD

10016

West

56472871

22.99

DVD

10017

West

26623353

20.91

Book

10018

West

78594431

20.16

Book

10019

West

92919041

18.11

DVD

10020

West

69868417

17.76

DVD

Quantity count

It is

Norte

On

West

Grand total

Book

anything

anything

anything

anything

anything

DVD

anything

anything

anything

anything

anything

Grand total

anything

anything

anything

anything

anything

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_2

Step: 3

blur-text-image_3

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

Business Analytics Methods Models And Decisions

Authors: James R. Evans

2nd Edition

321997824, 978-1119298588, 978-0321997821

More Books

Students also viewed these General Management questions