Manual Chart Table Formulas. Column H Category - cell H5 =IF (ISBLANK (L5),"X",L5) This simply picks up the category name from the Actuals PivotTable. The IF function checks if cell L5 containing the category name ISBLANK, if it is it will return an X (which I’ll use to locate the end of the data for my chart), and if it’s not then I’ll Learn how to insert, drag, sort, filter and change summary calculation of pivot tables in Excel with easy steps and examples. A pivot table allows you to extract the significance from a large, detailed data set and create a two-dimensional table. To filter the pivot table to only show data for players on the Mavs team or in a position of Guard, click the PivotTable Analyze tab along the top ribbon, then click Insert Slicer within the Filter group. In the new window that appears, check the box next to Filter and then click OK: In the new slicer that appears, click the “Show” button. Exercise Workbook: STEP 1: Here is our Pivot Table. Drag UNITS SOLD to the Values Area. STEP 2: This will default to Sum of UNITS SOLD. Let us change that by clicking on the arrow and selecting Value Field Settings. STEP 3: Select StdDevp and click OK. To do this, we can select the first column we want to unpivot, hold down the Shift key, and then click the last column. The results are shown below. Note: if you would like to undo a step in the Query Editor, you click the x in the Applied Steps list box. STEP 2: This will open up the Power Query Editor. Within here you need to select Transform > Pivot Column. STEP 3: This brings up the Pivot Column dialogue box. For the Values Column drop down, select the column name from our data that has the values in it…in our example it will be SALES. Click on advanced options and this will bring up the LnEe.