I’ve created new set of sample data to learn with, sample receivables data. My experience is that analyzing accounts receivable is one of the most powerful, money saving ways to use a Pivot Table. We start Excel Video 11 by analyzing accounts receivable by adding the balance due field to the Pivot Table twice. The trick is to sum the balance due the first time and count the balance due the second time. The other trick you’ll learn is how to move the sum of the values from columns to rows and back, depending on what you’re analyzing. There are a variety of uses for having the same data field in the data field twice. Look at the value field settings for more calculations (average, max, min, etc.) that are available in Pivot Tables.
Thanks for watching!