Today's author: Allan Folting, a program manager who works on the Excel team. I have gotten lots of questions from customers around specific functionality in Microsoft Excel 2007 PivotTables that is missing when connected to Microsoft SQL Server 2005 Analysis Services Service Pack 2 cubes: Filtering individual calculated members Showing non-visual totals when filtering I have also gotten lots of requests for the ability to add calculations to OLAP PivotTables using the object model, specifically...