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
Central Furniture $$$$
Office Supplies $ $ $ $
Technology $ $ $ $
East Furniture $$ $ $
Office Supplies $ $ $ $
Technology $ $ $ $
South Furniture $ $ $$
Office Supplies $ $ $ $
Technology $ $ $ $
West Furniture $ $ $ $
Office Supplies $ $ $ $
Technology $ $ $ $
Question 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
