Click “OK” to insert the Pivot Table in the worksheet, depending on the location selected.To analyze multiple tables, go to the option “Choose whether you want to analyze multiple tables” and click the below checkbox “Add this data to the Data Model.”.Note: Select “New Worksheet” if we prefer to insert a Pivot Table on the new worksheet (as shown in the below image). Under the option “Choose where you want the Pivot Table report to be placed,” select “Existing Worksheet” (shown in the below image). In this example of Excel Pivot Table, cell D1 is selected.The worksheet can either be the existing or a new one.
The next step is to choose the location of the Pivot Table report.In the “Table/Range” option, we can verify the selected cell range (shown in the below image).The data range is displayed in the “Table/Range” box under the “Select a table or range.”.Now under the option “Choose the data that you want to analyze,” Excel automatically selects the data range.
A “Create Pivot Table” window appears (as shown below).
0 kommentar(er)
