By default in Excel 2007 and Excel 2010, calculated members defined in your cube schema do not appear.
Calculated members are not supported by Excel 2003 or earlier versions.
- Right-click any cell in your PivotTable, and select PivotTable Options.
- Click the Display tab.
- Select the Show calculated members from OLAP server check box.
-
Click OK.