Which Item Number ID made the maximum sales across all assortments?

Using the Time-series table, create a cross tab showing the Sales for each Item Number-ID, broken down by Assortments, then add Grand totals to the view.

Which Item Number ID made the maximum sales across all assortments?
A . 584
B . 901
C . Correct)
D . 205
E . 660

View Answer

Answer: B

Explanation:

Follow along the steps below:

✑ Drag Assortment and Year ID to the column shelf, and Item Number ID to the row shelf. Next, drag Sales to the Text label to create a cross-tab as below: