Creating or Editing a Percentage

This dialog appears when creating a new percentage (by clicking on the Create percentage button) or editing a percentage (by clicking on the percentage name).

To define the percentage:

1. Enter a percentage name. This name will appear in the list of percentages on the Percentages tab and at the end of each measure name where this percentage is calculated.
2. Select the All selected option if you wish to see each member calculated as a percentage of the sum of all selected members. When members are added/removed from the table, the percentage is automatically recalculated.
3. Select the Specific member option to view each data point as a percentage of a specific total or subtotal.

The new Percentage is displayed on the Percentages tab.

To edit an existing percentage:

1. On the Percentages tab, click on the existing percentage.
2. On the Edit percentage dialog, make the necessary modifications.
3. When complete, click the Update percentage button to return to the Percentages tab of the Dimension Definition page.

Once a percentage has been created, it appears in the report as a new measure. If your Measures dimension is in the slicer area, you must bring it into the rows or columns to see the new measure. Alternatively you can cycle through the Measures’ members until you reach the new measure.

To display both the original data value and the percentage, make sure the Display values and percentages together check box is selected in the Total and percentage settings dialog (see Selecting Totals and Percentages Settings).