ExamGecko
Question list
Search
Search

Question 35 - TDS-C01 discussion

Report
Export

Using the Time Series table, create a cross-tab showing sales for each Assortment broken down by Year and Quarter. In Q4 of October 2017, what was the Average sales amount for the Hardware assortment?

A.
111,060
Answers
A.
111,060
B.
1,461
Answers
B.
1,461
C.
112,256
Answers
C.
112,256
D.
1,222
Answers
D.
1,222
Suggested answer: C

Explanation:

If you chose 111,060 you were SO close to the correct answer but made a small mistake - you didn't change the aggregation to AVERAGE! This is one of the common mistakes many test takers make, so keep this in mind.

To reach the correct answer, follow the steps below:

1) Draw Assortment to the Column shelf, and drag Year to the Rows Shelf. Then Drill down further on Year to accomodate Quarters and Months as well!

Although this seems enough, DON'T FORGET to change the aggregation like in the next step, which will completely change the values!

The correct answer as you can see is 1,461 - Sales for Harware Assortment in 2017 Q4, October

asked 23/09/2024
Tom Starren
43 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first