Using PivotTable data in a formula

When you create a formula, it's usually a good idea to draw the formula's values…from the original data source.…That way if the source changes, your formulas result will update the next time…Excel recalculates your workbook.…But what you do if your PivotTable contains data drawn from an outside source…and you can't get at the original tables?…In that case you can refer to a cell within the PivotTable using a GetPivotData formula.…Let's say that you want to use the data in a PivotTable cell in your…formula and for that we will make it the value in C6, which is the value…for January 2009 for FirmB.…

To create this formula, you start typing another formula such as Sum, so click…any cell outside the PivotTable and then type equal and then name of the…function, Sum, and then a left parenthesis and now you click the cell that you…want to use the data from inside the PivotTable.…So in this case I will click cell C6 and you see that Excel creates a GetPivotData function, …which has a bunch of information inside of it.…

Resume Transcript Auto-Scroll

Author

Released

4/19/2011

In Excel 2010: Pivot Tables in Depth, author Curt Frye provides comprehensive, hands-on tutorials on Excel PivotTables, including more advanced techniques such as using macros and the new PowerPivot add-in. The course shows how to connect and consolidate data sources to power PivotTables, sort and filter records, display data in a PivotChart, print tables and charts, and also introduces the DAX language for performing advanced summaries in PowerPivot. Exercise files are included with the course.