Excel Video 310 is the first step in our effort to demystify GETPIVOTDATA. As you’ll remember from our last Excel Video, Excel automatically creates a GETPIVOTDATA formula for you when you click to create a formula referencing a cell from a Pivot Table. Last time I showed you how to get around GETPIVOTDATA. Today we’ll start deconstructing GETPIVOTDATA so that we can get it to do what we need it to do.
You’ll see there are four parameters in a GETPIVOTDATA formula; the name of the field in the Values area, a cell reference from the Pivot Table, the name of the field (in the rows area this time), and the item from the rows area. In our example, we want data from the Sum of Allowed area in the Pivot Table that contains cell A8 and we want to look in the Primary Insurance field for an item called Medicare. Notice how when we change Medicare to a cell reference, A9, we can copy the GETPIVOTDATA formula as we need to.
That’s an introduction to GETPIVOTDATA. Stay tuned next time and we’ll dig a little deeper. Thanks for watching.
