Select Page

Lesson 10 shows how to add calculations to a Pivot Table by dragging more than one field to the values area of a Pivot Table. In this example, we use the same field twice in the same Pivot Table, once to count the number of new patients with each E&M code level and the second time to calculate the percentage of each E&M code level by physician. There are a variety of calculations that can be made by adding the same field twice to the Pivot Table values area. The video also shows you how to just work with percentages in a Pivot Table.