Analyze PivotTable data with 13 different Show Values As options

- [Narrator] This list is about 750 rows or so, … we want to analyze it by way of a pivot table. … We'd like to know how much money each department … is spending on compensation and some other things as well. … And we're going to be taking advantage of some of the built in … analytical capability of a pivot table. … This data has no empty rows or columns within it, … we simply click within the list, … go to the insert tab in the ribbon leftmost button, … pivot table and after verifying that this is correct here … the location of the data, we'll click okay … And we're on a new worksheet, … this pivot table field list can be anchored to the right … if you double click it's heading might be there already. … I'm going to click the box for department, … it's a text field. … It automatically appears in what we call the rows area. … And because compensation is a numeric field … click it's box, it goes into the values area … and let's expand this by putting in the status as well. … And over to the left where we see the pivot table, …