You have the following table. You need to create a PivotTable as shown in the following exhibit. What should you do?

Question

Exhibit

Options

• AAdd Product to the Rows area. Add LineTotal to the Values area twice.
• BAdd LineTotal to the Rows area. Add Product to the Values area twice.
• CAdd Product to the Rows area. Add LineTotal to the Columns area twice.
• DAdd LineTotal to the Rows area. Add Product to the Values area twice.

• A
  80% (28)
• B
  11% (4)
• C
  3% (1)
• D
  6% (2)

No community discussion yet for this question.