ExamGecko
Question list
Search
Search

List of questions

Search

Question 87 - Desktop Certified Associate discussion

Report
Export

Connect to the 'Global Superstore' data source and use the Orders table. Find out how many days in the 4th quarter of 2015 had a profit ratio greater than 25%?

A.
6
Answers
A.
6
B.
8
Answers
B.
8
C.
10
Answers
C.
10
D.
12
Answers
D.
12
Suggested answer: B

Explanation:

Calculate the Profit Ratio:

Create a LOD expression -> for each order date if profit ratio is greater than 25% returns 1.

Drop the Order date to Rows and drill-down it to Quarters.

Drop the profit ratio >.25 field to Text:

asked 23/09/2024
Jack de Cort
28 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first