Question

Move the Rep Name field to the Filters area, as the first field. Add the Classification field from the 1st Qtr Sales table in the PivotTable Fields List to the Rows area. Add the Month field from 1st Qtr Sales to the Columns box in the PivotTable. Apply Pivot Style Ice Blue, Pivot Style Medium 9 to the PivotTable and then close the PivotTable Fields pane.

          Move the Rep Name
field to the Filters
area, as the first
field.
Add the Classification field from
the 1st Qtr Sales table in the
PivotTable Fields List to the Rows
area.
Add the Month field from 1st Qtr
Sales to the Columns box in the
PivotTable.
Apply Pivot Style Ice Blue, Pivot
Style Medium 9 to the PivotTable
and then close the PivotTable
Fields pane.

Move the Rep Name
field to the Filters
area, as the first
field.
Add the Classification field from
the 1st Qtr Sales table in the
PivotTable Fields List to the Rows
area.
Add the Month field from 1st Qtr
Sales to the Columns box in the
PivotTable.
Apply Pivot Style Ice Blue, Pivot
Style Medium 9 to the PivotTable
and then close the PivotTable
Fields pane.

Added by Jeremy T.

Computer Science and Information Technology

Trishna Knowledge Systems 2018 Edition

Instant Answer

Solved by Expert Akash M

11/17/2023

Step 1

Step 1: Move the Rep Name field to the Filters area, as the first field. Show more…

Show all steps

Thanks for your feedback!

Move the Rep Name field to the Filters area as the first field. Add the Classification field from the 1st Qtr Sales table in the PivotTable Fields List to the Rows area. Add the Month field from 1st Qtr Sales to the Columns box in the PivotTable. Apply Pivot Style Ice Blue, Pivot Style Medium 9 to the PivotTable and then close the PivotTable Fields pane.