Display or hide ScreenTips and properties in a PivotTable or PivotChart report

A contextual ScreenTip is summary information about the value, row, or column for a field. For example, if you move the pointer over a cell in the values area, a contextual ScreenTip displays the current value and the row and column location. This contextual ScreenTip is especially useful when you are working with a large report and do not want to change the layout or scroll through the report to find or verify this information.

1. Click the PivotTable report.

2. On the Analyze tab, in the PivotTable group, click Options.

3. In PivotTable Options dialog box, click the Display tab and then, under Display, select the Show contextual tooltips check box.

If your PivotTable report is connected to a Microsoft SQL Server 2005 Analysis Services OLAP cube and the cube administrator has enabled the display of member property information, you can display the property values in a ScreenTip when you move the pointer over a field. For example, a product can contain additional property information, such as a product key, a dealer price, and a stock level. You can also control which specific property information is displayed in the ScreenTip.

1. Make sure that member properties are displayed for the PivotTable report by doing the following:

   1. On the Analyze tab, in the PivotTable group, click Options.

   2. In PivotTable Options dialog box, click the Display tab and then, under Display, select the Show properties in tooltips check box.

2. Right-click a field on the PivotTable or PivotChart report, point to Show Properties in Tooltips on the shortcut menu, and then click Show All Properties, Hide All Properties, or an individual property caption.

You can display member property information as data in the PivotTable report. For example, you may want to sort, filter, or print the property information.

When you filter member property data, the member property caption is displayed along with the field name. For example, if color is a member property of the Product field, you can filter products by the color silver.

1. Click the PivotTable report.

2. Make sure that member properties are displayed for the PivotTable report by doing the following:

   1. On the Analyze tab, in the PivotTable group, click Options.

   2. In PivotTable Options dialog box, click the Display tab and then, under Display, select the Show properties in tooltips check box.

3. Click the field in the dimension hierarchy for which you want to display property fields.

   If the levels for which you selected property fields aren't displayed in the report, click the field and then click the Expand button .

4. On the Analyze tab, in the Tools group, click OLAP tools, and then click Property Fields.

   The Choose Property Fields for Dimension dialog box appears.

5. In the Choose properties from level list, click each level for which you want to display property fields, and then double-click the property fields that you want to see.

6. In the Property fields to display box, use the and buttons to arrange the property fields in the order you want them to appear in the report.

7. Make sure that the Show fields for this dimension in outline form check box is selected, and then click OK.