square square square square square square square square square square square square square square square square square square square square square square square square square square square square square square 1st Qtr Sales square square square square square square square square D Type here to search 5 Points: XL Activity 4.02: Adding Fields to a PivotTable 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.

Question

square square square square square square square square square square square square square square square square square square square square square square square square square square square square square square 1st Qtr Sales square square square square square square square square D Type here to search 5 Points: XL Activity 4.02: Adding Fields to a PivotTable 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.

Answer 1

To add fields to a PivotTable in Excel, follow these steps:1. **Move the Rep Name field to the Filters area:** - Click on the "Rep Name" field in the PivotTable Fields list. - Drag it to the "Filters" area at the bottom of the window. - Release the mouse button to drop it in the "Filters" area.2. **Add the Classification field to the Rows area:** - Click on the "Classification" field in the PivotTable Fields list. - Drag it to the "Rows" area at the bottom of the window. - Release the mouse button to drop it in the "Rows" area.By following these steps, you will have successfully moved the "Rep Name" field to the Filters area and added the "Classification" field to the Rows area in your PivotTable.

Soru

Çözüm

Cevap