When you create a pivot table in Excel 2013, you are taking data from your spreadsheet and inserting it into, by default, a new format in another sheet of your Excel workbook. I have also changed the configuration of the task pane (task pane layout). A pivot table in Excel 2013 offers a variety of options for comparing data in columns, and grouping similar data in a way that would otherwise be difficult to do manually. Customers and Regions tables are expanded to show their column headers (field names). The following figure shows the Active tab of the PivotTable Fields task pane. We will ensure that the range includes the new data Figure 4- Change Pivot Table Data Source Dialog box. To take the Customers table under the Active tab, activate the All tab, right-click the Customers table, and choose Show in Active Tab from the options. We will click on the Pivot Table We will click Analyze, and then, Change Data Source Figure 3- Clicking on Change Data Source. You can take any table under the All tab to the Active tab. The Active tab lists only the Orders table and the All tab lists all the tables in the workbook. The task pane contains two tabs: Active and All. If you look at the PivotTable Fields task pane (on the right side of the newly created worksheet), you will find that it is a bit different as this time we’ve selected to work with Data Model. Select the Add This Data to the Data Model check box and click OK.
In this case, click Action>Move PivotTable. NOTE: Some Excel 2013 users may see an Action button instead. Next, click Move PivotTable in the Actions group. Select the Add This Data to the Data Model check box and click OK. To move a pivot table, click within the data of the pivot table, then click the Analyze tab under PivotTable Tools in the Ribbon, as pictured below. Step 2Ĭhoose the data that you want to analyze and Choose where you want the PivotTable report to be placed – these two options will be as it is. The Create PivotTable dialog box will appear. Select any cell within the Orders table and choose Insert ➪ Tables ➪ Pivot Tables. In that version, you can right-click on the table name in the field list, to add a new measure.
HOW DO I USE PIVOT TABLES IN EXCEL 2013 HOW TO
Here is the step by step process we have used to create the pivot table: Step 1 Count Unique Items in Pivot Table With Excel 2013 PowerPivot Last year, I described how to create a unique count in an Excel 2010 pivot table, by using the PowerPivot add-in. Therefore, we shall use all these three tables to create our target pivot table. Notice that the sales and date information is in the Order table, the state information is in the Customers table, and the region names are in the Regions table. Our goal in this example is to summarize sales by state, by region, and by year. In addition, you can’t create calculated fields or calculated items. The most notable one is: you can’t create groups. Note: A pivot table created using the Data Model has some restrictions, when compared with a pivot table created from a single data table.
0 kommentar(er)
