Apples are our main export product to France. Click the filter drop-down and select France. For example, which products do we export the most to France?ġ. Right click and click on Sort, Sort Largest to Smallest.īecause we added the Country field to the Filters area, we can filter this pivot table by Country.
Click any cell inside the Sum of Amount column.Ģ. To get Banana at the top of the list, sort the pivot table.ġ.
