by Nate Moore | Oct 31, 2012 | Pivot Tables
If you’d like to add running totals to a Pivot Table, watch Excel Video 306. It’s easy to add running totals to your Pivot Table, either as a number or as a percent. It’s also easy to sort to see the biggest or the smallest component of those running totals. If you’d...
by Nate Moore | Oct 29, 2012 | Pivot Tables
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...
by Nate Moore | Oct 24, 2012 | Pivot Tables
Would you like to show the actual distance from a baseline instead of a percentage distance in your Pivot Table? Watch Excel Video 304. Today we’ll show the actual dollar difference in billed charges instead of the percentage difference. We’ll also show both the total...
by Nate Moore | Oct 22, 2012 | Pivot Tables
Excel Video 303 introduces another way to calculate percentages in a Pivot Table. Today we’ll select a baseline amount for Excel to calculate percentages of in a Pivot Table. We’ll start by using Medicare as a baseline and comparing the other payers’ charges as a...
by Nate Moore | Oct 17, 2012 | Pivot Tables
Excel Video 302 has two shortcuts to make the percentage calculations we’ve been discussing easier to choose. Watch how in Excel 2010 there is a new Calculations menu and a new way to right-click a value in a Pivot Table to get faster, easier access to the Show Values...
