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

View Answer

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