PivotTables

Tips, Tricks, and Answers

The following articles are available for the 'PivotTables' topic. Click the article's title (shown in bold) to see the associated article.

Adding Weighted Averages to a PivotTable
PivotTables are used to boil down huge data sets into something you can more easily understand. They are very good simple aggregations, such as sums, counts, and averages. They can't do weighted averages, however. That doesn't mean you are out of luck; you can still calculate weighted averages using the ideas in this tip.

Using a PivotTable to Count Items
One of the ways you can use PivotTables is to generate counts of various items in a data table. This is a great technique if your data table has quite a few items in it.