Select the Add This Data to the Data Model check box and click OK. 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. Here is the step by step process we have used to create the pivot table: Step 1 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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |