Question: To create the table below, which shows the yearly regional profit for each category, what actions would you need to take? Order Date Region Category

To create the table below, which shows the yearly regional profit for each category, what actions would you need to take?
Order Date
Region Category 2014201520162017
Central Furniture -$1,105-$231-$254-$1,281
Office Supplies $622 $1,780 $6,392 $85
Technology $1,022 $10,168 $13,761 $8,747
East Furniture -$500-$47 $1,413 $2,180
Office Supplies $6,725 $11,041 $11,499 $11,750
Technology $10,834 $10,098 $7,229 $19,301
South Furniture $4,001 $209 $3,146-$584
Office Supplies $5,271 $3,610 $5,325 $5,780
Technology $2,607 $4,500 $9,232 $3,653
West Furniture $3,062 $3,085 $2,654 $2,704
Office Supplies $9,974 $8,669 $11,845 $22,121
Technology $7,029 $8,738 $9,552 $18,984
Question 10 options:
a)
Drag Region and Category to the Columns shelf, Order Date to the Rows shelf, and Profit to the table.
b)
Drag Region and Category to the Rows shelf, Order Date to the Columns shelf, and Profit to the table.
c)
Drag Region, Category, and Order Date to the Columns shelf and Profit to the table.
d)
Drag Region, Category, and Order Date to the Rows shelf and Profit to the table.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!