ExamGecko
Question list
Search
Search

List of questions

Search

Question 18 - Desktop Certified Associate discussion

Report
Export

Connect to the 'Global Superstore' data source and use the Orders table. Create a bar in bar chart and compare the profit against the target profit for Canada Region. Consider target profit is 30% of the sales. Which of the following sub-categories has met or exceed the target profit?

A.
Tables
Answers
A.
Tables
B.
Paper
Answers
B.
Paper
C.
Labels
Answers
C.
Labels
D.
Copiers
Answers
D.
Copiers
Suggested answer: A, C, D

Explanation:

Drop Region at the filter and Select Canada

Drop Profit to columns and Sub-Category to Rows

Then drop the target profit to profit axis, it will create the combined axis chart.

Now drop the Measure Names field from the Rows to the Color Marks Card.

Go to the Analysis menu -> Stack Marks -> Off (so that your both profit and target profit bars will start from 0)

Tables, Labels and Copiers sub-categories has met or exceed the target profit.

asked 23/09/2024
Mustapha Amine Atmani
46 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first