Pivot tables are one of Excel’s most powerful data analysis tools, used extensively by financial analysts around the world. In a pivot table, Excel essentially runs a database behind the scenes, allowing you to easily manipulate large amounts of information. How to Use a Pivot Table in Excel. Below is a step by step guide of how to insert a An example from Coefficient.io, building a cloud Pivot Table using data from Salesforce. You can build the same Cloud Pivot Tables for databases. Step 1: Select the table and fields you want to include in the pivot table. Step 2: Select the columns and rows you want to include in each of your measures. Click on " Add filter ," select " New Filter ," click on the dropdown, and expand " All data ." Next, choose the table that contains the needed field (in this case, it's the " Date " table), and then select the field name. The new filter will appear at the top left and have selections like what you find in a Pivot table filter (see image below). For more information, see Create a Relationship Between Two Tables or Create relationships in Diagram View. Top of Page. Blank Rows in Pivot Tables (Unknown Member) Because a PivotTable brings together related data tables, if any table contains data that cannot be related by a key or by a matching value, that data must be handled somehow. We’ll cover some very basic things about creating a Pivot Table. Let’s start with a blank Excel file and source data. It’s very easy to add a pivot table: Select your source data and go to Insert > Pivot Table > From Table/range. Go to the "Insert" tab and click on "PivotTable." This will open the "Create PivotTable" dialog box. In the dialog box, select the range of cells you want to use for the pivot table. Choose where you want to place the pivot table – either in a new worksheet or in an existing one. Create a pivot table to summarize sales data by product and region: Step 1: Select the sales data range. Step 2: Click Insert > Pivot Table. Step 3: Drag the Product field to the Rows area and the Region field to the Columns area. Step 4: Drag the Sales field to the Values area. Step 5: Click Finish. To add a Pivot Table to your spreadsheet, go to the sheet (the first cell) where you want the Pivot Table summary inserted. Go to the Insert Tab > Pivot Table (Or press the Alt Key > N > V) to launch the insert Pivot Table dialog box. Refer to the cells containing the data. Check the option for a ‘New Worksheet’. Click Okay. jePs.