Changing Data Displays

You can change how members (values) of dimensions and attributes are displayed in the crosstab: text only, key, or a combination of the two. Select the column header containing the dimension/attribute name and choose the desired option from the Members menu option in the Analysis ribbon.

The figure shows the Members button in the Analysis ribbon to change how members are displayed in the crosstab.

You can specify the number format for each measure in your analysis, including the scaling factor, decimals used (Number Format . . .), currency conversion, and how zero and negative values are displayed (General Format . . .). Select the column header containing the measure name and choose the desired option from the Measures menu option in the Analysis ribbon.

The figure shows the Measures button in the Analysis ribbon to change how measures are displayed in the crosstab.

You can define whether totals are displayed in the crosstab, and if they are displayed, you can decide where they are displayed. You can also define how the totals can be calculated. Select the column header containing the measure name and choose the desired option from the Totals menu option in the Analysis ribbon.

The figure shows the Totals button in the Analysis ribbon to change how Totals are displayed in the crosstab

By default, totals are usually summed. However, you can change the totals calculation if that is helpful to your analysis. Select the column header containing the measure name and choose the desired option from the Totals→Calculate Totals As menu option in the Analysis ribbon.

The figure shows the Calculate Totals As options.

Watch the video to see how to change data displays.

Let's summarize:

• Dimension/Attribute Displays: Choose display format (text, key, combination) from Members menu.
• Measure Displays: Customize number format, scaling, currency, zero/negative values from Measures menu.