Step 2: Select the first option for both questions, i.e., What kind of report do you want to create?.The PivotTable and PivotChart, Wizard dialogue box, open up. Step 1: Press the keys ALT + D + P on the keyboard Here, we will use the alternative method to create the Pivot table. We want to find the total sales of all the products using the Pivot Table. The table below shows sales of Product 1, Product 2, Product 3, Product 4, Product 5, Product 6, Product 7, Product 8, and Product 9 in the year 2017 in quarters- Q1, Q2, Q3, and Q4. The above table shows the total count of Incorrect Property IDs.

Step 4: Select the Incorrect option from the filter (dropdown) to get the below result The above table shows the total number of Property IDs marked as correct to be 13. Step 4: Click on the Correct checkbox > Select Multiple Items > OK Step 3: Click on the Filter section dropdown in the table Now, we want to count the number of Property_IDs marked as Correct The table shows the Total count ( 17) of the Property_IDs checked by the auditors. Step 3: Drag the Auditor field to the area Rows, Property_ID to Values, and Status to Filters. We can place the data fields into the desired area by dragging them or clicking the checkbox next to the data field. Columns: Values under different conditions.Filters: Filters to select the desired data field.Rows: Data that is taken as a specifier.At the bottom of the Pivot Table Fields pane are four areas ( Rows, Values, Filters, and Columns) where we need to place the data fields. To enter data into it, click anywhere on the Pivot table, and we can see a Pivot Table Fields pane on the right side of the Excel Window, as shown below.Īt the top, the Pivot Table lists fields (data table columns). Now, click OK, and the below Pivot Table will be created. For this, click the desired cell, which will be displayed in the Location option in the dialogue box. Now, we have to specify the location (cell) for the Pivot Table. Next, we must select whether we want the Pivot table in the New Worksheet or the Existing Worksheet.

Excel 2016 pivot table cheat sheet