From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 22,400 courses taught by industry experts.

Use calcuated fields and calculated items in a PivotTable

Use calcuated fields and calculated items in a PivotTable - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Use calcuated fields and calculated items in a PivotTable

- [Voiceover] Excel's PivotTable feature is a great tool for getting good, quick summary information out of a list. This list here is about 900 rows. I'll click on a cell, double click the bottom edge, goes down to row 910, down here I'll double click the top edge. We've got some data here. I'm going to create a PivotTable. There will be times when you do need to use formulas in PivotTables, and there's a feature called a calculated field. There's one called a calculated item. We'll show you both of them. I'm going to create a PivotTable on a new sheet. I'll simply click on the insert tab, click PivotTable, quick look here to make sure Excel gets these cells right for the extent of the data it does, nearly always does. I could put it on this worksheet, but I won't. I'll simply click OK. We'll be on a new worksheet, and the PivotTable Fields list to the right appears. By the way, that typically is docked on the right, if you want to make it float, you can drag it out here, you can also…

Contents