Exam4Training

In Q4 of October 2017, what was the Average sales amount for the Hardware assortment?

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
B . 1,461
C . 112,256
D . 1,222

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

Latest TDS-C01 Dumps Valid Version with 151 Q&As

Latest And Valid Q&A | Instant Download | Once Fail, Full Refund

Exit mobile version