by Nate Moore | Nov 14, 2012 | Pivot Tables
Excel Video 310 is the first step in our effort to demystify GETPIVOTDATA. As you’ll remember from our last Excel Video, Excel automatically creates a GETPIVOTDATA formula for you when you click to create a formula referencing a cell from a Pivot Table. Last time I...
by Nate Moore | Nov 12, 2012 | Pivot Tables
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...
by Nate Moore | Nov 7, 2012 | Pivot Tables
Excel Video 308 gives us one more way to show values in a Pivot Table. Truth be told, we didn’t necessarily save the best for last, but we did save the most complicated calculation for last. Microsoft uses the index calculation we’ll discuss today to describe the...
by Nate Moore | Nov 5, 2012 | Pivot Tables
If you’d like to see how components of your Pivot Table change over time, try ranking the values in Excel Video 307. Excel will let you rank from lowest to highest or from highest to lowest based on whatever baseline value you choose in your Pivot Table. You’ll see in...
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...
