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
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: