MS Excel: How to Use Calculated Fields and Items in Pivot Tables - A Tutorial for Excel Users


In this video, we will explore the important features of pivot tables, called calculated fields and calculated items. These features add calculated rows and columns, from existing rows and columns, in the pivot table. We will create a pivot table from a small dataset and drag the amount field to the values area. We will then add the branch field to the column area and the type and product category fields to the rows area. We will rename the column and row labels appropriately and hide the blank columns and rows. We will also add calculated fields and items, from the pivot table analyze tab. We will create a calculated field to calculate tax on our sales, which will be calculated at 17 percent on sales, which is the amount column. We will then change the title of the calculated field from sum of tax to tax. We hope you enjoy and understand our tutorial. Excel file: #PivotTables, #CalculatedFields, #CalculatedItems, #ExcelTutorial, #dataanalysis Chapters: 00:22 - Creating a Pivot Table 02:38 - Adding Calculated Fields 03:42 - Adding Calculated Items


pivot tables, calculated fields, calculated items, Excel, tutorial, data analysis
© 2023 - Virtual School of Information Technology