Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Now we need to show sales for months within each year. The months should be selected such that the sum of sales is for each

Now we need to show sales for months within each year. The months should be selected such that the sum of sales is for each month across all 4 years. To do this, click the ( ) on the left next to "YEAR(Order Date)" in the Columns shelf. You will see "QUARTER(Order Date)" added to the Columns shelf, and the line chart will be updated to show each quarter. But we need to show the months, not quarters, so click the dropdown arrow next to "QUARTER(Order Date)" and select "Month" (Tip: use the following format: May). The view will be updated showing sum of sales by months of Order Dates across all the years. (6 points) g) Locate the Segment dimension in the variable list on the left and drag and drop it into the Filters card. An options screen will appear. Select "Use all" and click OK. (2 points)

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

Algebra Math 1st Grade Workbook

Authors: Jerome Heuze

1st Edition

979-8534507850

More Books

Students also viewed these Mathematics questions

Question

6 Describe the contents of a destination marketing plan.

Answered: 1 week ago