Excel Video 305 shows you another way to look at percentage differences in a Pivot Table. If you watched Excel Video 303, we calculated percentage differences from a baseline and found payers that were 96% of Medicare or 105% of Medicare. If you’d rather show those percentages as 4% less or 5% more than Medicare, here’s how to do it. There’s not a right or wrong way to show these percentage changes. You may find the 105% works better in some Pivot Tables and the negative 4% works better in other Pivot Tables. As long as you and your readers are clear about which approach you’re using it’s great to have the flexibility to express percentages both ways.
Stay tuned. Next time we’ll start talking about how to show additional calculations inside Pivot Tables. Thanks for watching.
