The following article is available from the Microsoft Excel team blog, which provides useful articles and news about Excel and Excel Services from the Excel product group and occasional guest contributors.
Common Questions Around Excel 2007 OLAP PivotTables
Summary: Discusses four common customer questions about using PivotTable reports with OLAP data: (1) Filtering individual calculated members, (2) showing non-visual totals when filtering, (3) adding calculated members/measures, (4) and adding named sets.