Siebel Analytics User Guide > Working with Siebel Analytics Views > Working with Siebel Analytics Pivot Table Views >

Showing an Item's Relative Value in Siebel Analytics Pivot Tables

You can dynamically convert a stored or calculated measure on a pivot table into a percent or an index. This shows the relative value of the item, compared to the total, without the need to explicitly create a calculation for it.

For example, if you are using a pivot table to examine sales by region, you can duplicate the sales measure and view it as a percentage of the total. This allows you to see the actual sales, and the percentage of sales, that each region accounts for.

You can view the measure as a percentage between 0.00 and 100.00, or as an index between 0 and 1. Deciding which method to use is at your discretion.

To show an item as a relative value

  1. Click the More Options icon for the item you want to show as a relative value.
  2. To duplicate the measure, select the option Duplicate Layer.

    3. The measure is displayed a second time in the pivot table, with the same name. If you want to rename the measure, click More Options and select Rename.

    NOTE:  This step is optional. When you duplicate the measure in the pivot table, you can see both the total for the measure and its relative value. This eliminates the need to add the column twice on the Criteria tab to see the total and its relative value in the pivot table.

  3. Select the option Show Data As and choose Percent of or Index of, and then the appropriate submenu option.

    4. NOTE:  The option Show Data As is available only for items that are stored or calculated measures.

    The options for Percent of and Index of are shown below. For Percent of choices, the number of decimal places displayed is dependent upon the type of measure.

    Percent of or Index of
    Result
    Column
    Shows the percentage of the column, or index value, that this value constitutes.
    Row
    Shows the percentage of the row, or index value, that this value constitutes.
    Section
    Shows the percentage of the section, or index value, that this value constitutes.
    Page
    Shows the percentage of the page, or index value, that this value constitutes.
    Column Parent
    Shows the percentage of the column parent, or index value, that this value constitutes.


 Siebel Analytics User Guide 
 Published: 18 April 2003