PivotTable reports can do more than add.
In the last lesson, Excel automatically added up the quarterly sales totals by using Sum, which is called, naturally enough, a summary function. Excel has other summary functions, such as Count, Max, and Average, and in this lesson you'll use the Count function to see how to figure out the number of sales made by each salesperson.
You'll also learn how to use a custom calculation to show salesperson totals as a percentage of the total dollars sold. In the practice session you'll have a chance to try out what you've learned.
To continue reading this lesson on your own, click Next.