Select Page

Excel Video 309 transitions to a different way to do calculations with Pivot Table data. We’ll start with a little housekeeping to get the data the way we’d like it, and then the first thing I want to show you is that you can put multiple fields in the Values area of a Pivot Table. In today’s example, we want to analyze reimbursement, so we’ll drag both the write off and allowed fields into the Pivot Table and format them appropriately.
Now that we have the fields we need in the Pivot Table, watch what happens when I try to arrow to or click on a Pivot Table field. Excel creates a GETPIVOTDATA formula for us. There are pros and cons to GETPIVOTDATA and we’ll certainly discuss GETPIVOTDATA in upcoming videos. What I want to show you today is a quick and dirty way to get a formula using Pivot Table data without using GETPIVOTDATA. Instead of clicking on the cells for the formula or using the arrow keys to point to the cells for the formula, simply type the formula = D9/B9 in the cell. This hand-typed formula can then be copied like a normal Excel formula.
Watch the upcoming Excel Video for how to use GETPIVOTDATA. I look forward to seeing you then.