Using PivotTable data in a formula


show more Using PivotTable data in a formula provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2010: Pivot Tables in Depth show less
please wait ...

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...

Using PivotTable data in a formula
Video duration: 4m 47s 3h 43m Intermediate

Viewers:

Using PivotTable data in a formula provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2010: Pivot Tables in Depth

Subject:
Business
Software:
Excel
Author:
please wait ...