spacenomad.blogg.se

The data pertaining to South and West regions only will get summarized. Then check the boxes - South and West and click OK.

Check the box Select Multiple Items.īy default, all the boxes are checked. Sum of Order Amount Month-wise appears in the row Grand Total.Ĭlick on the arrow in the box to the right of the Filter Region.Ī drop-down list with the values of the field Region appears. Sum of Order Amount Salesperson-wise appears in the column Grand Total. Summarizing value is Sum of Order Amount. Region Filter appears on the top with default selected as ALL.

The Filter with the label as Region appears above the PivotTable (in case you do not have empty rows above your PivotTable, PivotTable gets pushed down to make space for the Filter. You can assign a Filter to one of the fields so that you can dynamically change the PivotTable based on the values of that field.ĭrag Region from Rows to Filters in the PivotTable Areas. You will understand filtering by the other methods mentioned above in this chapter.Ĭonsider the following PivotTable wherein you have the summarized sales data region wise, salesperson wise and month wise. You will learn filtering data using Slicers in the next chapter. There are several ways to do that as follows − You can filter the data in the PivotTable based on a subset of the values of one or more fields. This might be because you have large data and your focus is required on a smaller portion of the data or irrespective of the size of the data, your focus is required on certain specific data. You might have to do in-depth analysis on a subset of your PivotTable data.