Select Page

In Lesson 13 I showed how use GETPIVOTDATA to create formulas outside the Pivot Table based on Pivot Table data. In Lesson 14, I showed another way to create formulas using Pivot Table data. Both formulas were outside the Pivot Table looking into the data. Lesson 16 shows a way to create a formula called a calculated field that’s stored inside the Pivot Table. You can base the formula on Pivot Table fields, like I do in the video, or you can just use one field and a constant, such as = Billed Charges * 1.1 to generate a field that takes 110% of the Billed Charges field.

There are good applications for all three ways to create formulas. Once you know a variety of ways to use Pivot Table data, you can choose the best method to meet a specific need.

To do this demonstration, it was easier to use a set of data I created for the MGMA 2009 Annual Conference in Denver. Note that in evaluating reimbursement, I dragged three separate fields to the values area of the Pivot Table, Billed Charges, Write Off, and Allowed. You aren’t limited to having only one field in the values area of a Pivot Table. Reimbursement’s a place where it’s helpful to look at multiple value fields.

Best of luck learning Pivot Tables.