How do you make Pivot table to show calculated members from Analysis Services 2005

Written by Vidas Matelis. Posted in Excel FAQ

Q: How do you make Pivot table to show calculated members from Microsoft SQL Server Analysis Services 2005?

A: By default in Excel 2007 Pivot tables does not show calculated members in dimensions. To do that you have to anywere in Pivot table do right mouse click and then choose "Pivot Table options..", then in the "Display" tab check "Show calculated members from OLAP Server" checkbox.

Tags: excel, faq