To easily compare these numbers, create a pivot chart and apply a filter. More about PivotTables and the Data Model.
Click Open, and then click OK to show a Field List containing all the tables in the Data Model. Next, to get the total amount exported to each country, of each product, drag the following fields to the different areas.īelow you can find the two-dimensional pivot table. On the Tables tab, in This Workbook Data Model, select Tables in Workbook Data Model. If you drag a field to the Rows area and Columns area, you can create a two-dimensional pivot table. 16 out of the 28 orders to France were 'Apple' orders. Choose the type of calculation you want to use. Right click and click on Value Field Settings.ģ. Click any cell inside the Sum of Amount column.Ģ. To change the type of calculation that you want to use, execute the following steps.ġ. Change Summary Calculationīy default, Excel summarizes your data by either summing or counting the items. If you look at the tables closely, you will find that the Orders and Customers tables have the CustomerID column as common, and the Customers and Regions tables have the State column as common (download the working file to see the common things).We shall use these common columns to form relationships among the tables. Note: you can use the standard filter (triangle next to Row Labels) to only show the amounts of specific products. Apples are our main export product to France. Under Choose the data that you want to analyze, select Select a table or range. Note: Your data shouldnt have any empty rows or columns.
#MAKING PIVOT TABLES IN EXCEL 2013 WINDOWS#
Click the filter drop-down and select France. Create a PivotTable in Excel for Windows Select the cells you want to create a PivotTable from. For example, which products do we export the most to France?ġ. Because we added the Country field to the Filters area, we can filter this pivot table by Country. , by placing the fields by which you want to summarize the data in VALUES area, you arrive at the summary table.
0 kommentar(er)
