Bringing it all together - Business Intelligence in Microsoft SharePoint 2013 - page 318

2. Scroll through the field list and select the check boxes next to the following PivotTable
fields: DimDate: FiscalYear, Measure: Sum of SalesAmount, and DimSalesTerritory:
SalesTerritoryCountry.

This adds the primary data to the spreadsheet with which we are working.

Drag the SalesTerritoryCountry field from the Rows area to the Filters area, as demonstrated in
Figure 10-8 as before-and-after illustrations.

3.

FIGURE 10-8 PivotTable Fields.