Question 1 Create a Pivot Table to analyze the data below by country, yr of sales and category Show the sales per country and the summary of sales in the pivot table Country Region Year Category Product sales ratings Botswana North 2018 Clothing shorts 13300 75 south africa North 2019 bikes mountain bikes 6500 50 Namibia Central 2020 clothing socks 5000 55 Swaziland North 2019 components bottom brackets 8000 80 south africa Central 2020 accessories ear rings 500 25 Namibia Central 2021 Clothing socks 980 25 Botswana North 2021 bikes mountain bikes 21000 88 Botswana South East 2021 accessories hair pins 300 36 Namibia Central 2021 components locks 29700 94

The Answer is in the image, click to view ...

Question: Question 1 Create a Pivot Table to analyze the data below by country, yr of sales and category. Show the sales per country and the

Question 1

Create a Pivot Table to analyze the data below by country, yr of sales and category. Show the sales per country and the summary of sales in the pivot table

Country	Region	Year	Category	Product	sales	ratings
Botswana	North	2018	Clothing	shorts	13300	75%
south africa	North	2019	bikes	mountain bikes	6500	50%
Namibia	Central	2020	clothing	socks	5000	55%
Swaziland	North	2019	components	bottom brackets	8000	80%
south africa	Central	2020	accessories	ear rings	500	25%
Namibia	Central	2021	Clothing	socks	980	25%
Botswana	North	2021	bikes	mountain bikes	21000	88%
Botswana	South East	2021	accessories	hair pins	300	36%
Namibia	Central	2021	components	locks	29700	94%

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 General Management Questions!

use excel or a similar software to create a pivot table of the following data. answer should look like this Aa June 6, 2021 at 10:46 PM 1. For this learning activity, use the "Bike_Sales.xlsx" file....

Phoenix Entertainment (Financial Accounting) Learning objectives 1. Create a pivot table in Excel 2. Format a pivot table 3. Apply filters to a pivot table 4. Sort a pivot table . 5. Create sum...

I need help with part 2 item 1 please. I have screen shotted the documents required. The attached spreadsheet (CrookEd Salary Expenses 2011-2014) contains the data you discovered. The first tab is a...

Dataset (`handy-bonbon-142723.order_entry_dataset`) available on Google BigQuery. 1) Write a SQL statement to show the total dollar amount sold to customers summarized by state/province of their...

House Divided Company: Sales, Cost, and Contribution Margin Analysis (Managerial Accounting) Learning objectives 1. Find and correct errors in a data set (clean the data) Add columns containing...

Excel Skills: Pivot Tables 1. Download and read the article "Make Excel an Instant Know-It-All, 2. Create a Spreadsheet containing the data in Exhibit 1 and name it Input" a. To create a Pivot Table...

Instructions - - - DO NOT HARDCODE ANYTHING 1 Create a Pivot Table Using All Data in the Sales Transactions tab. Once created, please name this tab "Pivot" 2 While formatting the Pivot table, please...

The company reports sales made by each sales consultant on a quarterly basis. The extract from sales for current FY is below. 1. Create a pivot table to show data per sales consultant per quarter...

Question 1 Create a decision tree for the following data set. The objective is to predict the class category (loan approved or not). a. Analyze the data as vou have learned showing step by step...

You recently joined Grand and Toy as an accounting intern. The accounting manager, Sophie Lamda, met with you and handed over your first assignment. Sophie: Good morning intern, welcome to Grand and...

Under what circumstances is an inventory rollback or roll-forward typically performed? How valid is the evidence yielded by this audit procedure? Explain.

Rhaman Company had the following transactions in its first month of operations: 1. The owner invested $10,000 cash in the business, plus some office furniture and equipment that had originally cost...

*CA3.6 (LO 3, 4, 6) Ethics (Classification of Income Statement Items) As audit manager for Grupo and Rijo, you are in charge of reviewing the classification of unusual items that have occurred during...

What is an example of constructive feedback? provide reference