ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 5 - 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 month of May 2012 were profitable?

A.
16
Answers
A.
16
B.
18
Answers
B.
18
C.
20
Answers
C.
20
D.
22
Answers
D.
22
Suggested answer: C

Explanation:

Here we have created the Fixed LOD expression and fixing the order date. If profit is greater than 0 it means profitable day/month/quarter/year depends on what you need to find. If profit < 0 then not profitable.

Drop the Order Date to the rows and drill-down it till months.

Drop the profitable days field to the Text, aggregated as SUM. So it will find a number of days.

asked 23/09/2024
Luis Antonio Sanchez Estrada
35 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first