In the Data Explore sheet, the Rows area of the PivotTable should only contain the Months field. (This will be marked correctly on performing step 8.)
3 answers
Step 8 likely involves filtering the Rows area of the PivotTable to only include the "Months" field. This means that only the months will be displayed in the Rows area, and no other fields or categories will be included. By performing this step correctly, the PivotTable in the Data Explore sheet will have the appropriate layout and organization.
how do I filter it on excel so only months show
To filter the Rows area of a PivotTable in Excel to only show months, you can follow these steps:
1. Select the PivotTable in the Data Explore sheet.
2. In the PivotTable Field List, locate the field that contains the dates. For example, if you have a field named "Date," find that field.
3. Click on the drop-down arrow next to the field name.
4. A menu will appear. Select "Filter > Date Filters."
5. Another menu will appear with various filter options. Select "Months."
6. Now, a dialog box will open where you can select the specific months to include or exclude. By default, all the months might be selected. You can uncheck the months you do not want to include, or you can select the "Select All" button to deselect all months and then individually check the months you want to include.
7. After selecting the desired months, click the "OK" button.
Once you follow these steps, the Rows area of the PivotTable will only display the selected months. The other months will be filtered out.
1. Select the PivotTable in the Data Explore sheet.
2. In the PivotTable Field List, locate the field that contains the dates. For example, if you have a field named "Date," find that field.
3. Click on the drop-down arrow next to the field name.
4. A menu will appear. Select "Filter > Date Filters."
5. Another menu will appear with various filter options. Select "Months."
6. Now, a dialog box will open where you can select the specific months to include or exclude. By default, all the months might be selected. You can uncheck the months you do not want to include, or you can select the "Select All" button to deselect all months and then individually check the months you want to include.
7. After selecting the desired months, click the "OK" button.
Once you follow these steps, the Rows area of the PivotTable will only display the selected months. The other months will be filtered out.
1 answer