Using data in a formula


show more Using data in a formula provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2008 for Mac: Pivot Tables for Data Analysis show less
please wait ...

Using 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 formula's result will update the next time Excel recalculates your workbook. But what do you do if your Pivot Table contains data drawn from an outside source and you can't get out the original tables? In that case, you can refer to a cell within the Pivot Table using a GetPivotData formula. I will work my first example on the same worksheet as the Pivot Table so you can follow along more easily, and then I will create a more realistic example on another worksheet. A GetPivotData formula uses two arguments.

First I will type in the function name and left parenthesis, and the two arguments that the GetPivotData function takes are Pivot_Table and the name. Pivot Table refers to any cell within the Pivot Table. I always use the cell at the top left corner of the Pivot Table, in this case cell A3, because I know it's not going...

Using data in a formula
Video duration: 5m 18s 1h 7m Intermediate

Viewers:

Using data in a formula provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2008 for Mac: Pivot Tables for Data Analysis

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