Display or hide screentips and properties in a pivottable or pivotchart report

A ScreenTip provides contextual or supplementary information, such as member properties in an Online Analytical Processing (OLAP) cube, about a field in a PivotTable or PivotChart report.

Newer versions2010, 2007



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.

Note: This procedure requires a field to have properties defined and enabled on the OLAP cube. To find out if properties are available, right-click the field, and then point to Show properties in Report on the shortcut menu. If the shortcut menu displays (No Properties Defined), no properties are available to be displayed.

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.

Note: This procedure requires that a field have properties defined and enabled on the OLAP cube. To find out whether properties are available, right-click the field, and then point to Show properties in Report on the shortcut menu. If the shortcut menu displays (No Properties Defined), no properties are available to be displayed.

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.

Note: In column fields, property fields are displayed only for items in the lowest level of detail displayed in the report. To display property fields for other levels, move the field to the row label area.

Tip: You can also right-click the label field, point to Show Properties in Report on the shortcut menu, and then click Show All Properties, Hide All Properties, or an individual property caption.

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 Options 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.

Note: This procedure requires a field to have properties defined and enabled on the OLAP cube. To find out if properties are available, right-click the field, and then point to Show properties in Report on the shortcut menu. If the shortcut menu displays (No Properties Defined), no properties are available to be displayed.

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

   1. On the Options 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.

Note: This procedure requires that a field have properties defined and enabled on the OLAP cube. To find out whether properties are available, right-click the field, and then point to Show properties in Report on the shortcut menu. If the shortcut menu displays (No Properties Defined), no properties are available to be displayed.

1. Click the PivotTable report.

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

   1. On the Options 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 Options 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.

Note: In column fields, property fields are displayed only for items in the lowest level of detail displayed in the report. To display property fields for other levels, move the field to the row label area.

Tip: You can also right-click the label field, point to Show Properties in Report on the shortcut menu, and then click Show All Properties, Hide All Properties, or an individual property caption.

Need more help?

You can always ask an expert in the Excel Tech Community or get support in the Answers community.