In recent blog posts, we’ve looked at the pivot table Count function, the Average function, and the Min and Max functions. In this article we’ll look at the Product function. Product Summary Function The Product summary function shows the result of multiplying all the underlying values in the Values area. The result is the same [...]

You can create custom PivotTable Styles in an Excel 2007 workbook, to fine tune the appearance of your pivot tables. If you’ve invested a lot of time in create a custom style, you might like to copy that style to a different workbook. Unfortunately, there isn’t a built-in command that will let you copy PivotTable [...]

Changes being made to the relational warehouse and cube schema in Team Foundation Server 2010 will affect existing Excel pivot tables/charts that are authored against the warehouse or cube. To learn more, you can read the article on Sunder Raman’s Blog.

If there are blank cells in one of the fields in your source data, you might want to show a count of the blank cells in the pivot table. In this example there’s a Region field in the source data, and some of the records have no region name entered. In the pivot table, you’d [...]

You might have to make changes to a workbook that contains a pivot table. If someone else created that workbook, you may not be sure where to find the Excel table that was used as the pivot table’s source data. In some workbooks there can be several Excel tables, and it’s not immediately obvious which [...]

To prevent old items from being retained in an Excel 2007 pivot table, you can change an option setting, as shown in the short video below: Right-click a cell in the pivot table Click on PivotTable options Click on the Data tab In the Retain Items section, select None from the drop down list. Click [...]

Usually, when you add a field to the Values area in a pivot table, it automatically uses the Sum function. Sometimes though, a field automatically uses the Count function. You might not understand why different functions are used for two fields that contain similar data. If there are blank cells, or non-numeric data in the [...]