Updating pivot tables in excel 2016
To get the total amount exported of each product, drag the following fields to the different areas. To get Banana at the top of the list, sort the pivot table. By default, Excel summarizes your data by either summing or counting the items. Note: you can use the standard filter (triangle next to Product) to only show the totals of specific products.
For example, which products do we export the most to France?
On the Options tab, click the Sort Largest to Smallest button (ZA). Because we added the Country field to the Report Filter area, we can filter this pivot table by Country. To change the type of calculation that you want to use, execute the following steps.