Percent Calculation
The 'Percent' calculation allows you to express the measure based on 'Grand Total', 'Subtotal', or a particular dimensional group.

• Dimension: Expresses the value of the aggregated measure for each group as a percentage of the measure aggregated across the selected dimension.
• Grand Total: Expresses the value of the aggregated measure for each group as a percentage of the measure aggregated across all groups.
• Subtotal: For a facet-type chart (i.e., a chart with both a measure and dimension on Y-axis), this expresses the value of the aggregated measure for each group as a percentage of the measure aggregated across all groups on the same sub-chart.
In this example, you will create a chart that displays the quantity of products sold for different categories, regions, and states. You will display the aggregated measure for each subgroup as a percentage of the total aggregate for the category. Follow the steps below:
1. Create a new Viewsheet based on the sample 'Sales Explore' Worksheet in the 'Sales' folder.
2. Drag a Chart component onto the Viewsheet grid.
3. Click the center of the Chart (or click the 'Edit' button at the top-right). This opens the Chart Editor.
4. In the Chart Editor, make the following selections:
a. From the 'Dimensions' node in the Data Source panel, drag the 'Category' dimension to the 'X' field in the Data panel.
b. From the 'Measures' node in the Data Source panel, drag the 'Quantity Purchased' measure to the 'Y' field in the Data panel.
c. From the 'Dimensions' node in the Data Source panel, drag the 'Region' dimension to the 'Y' field in the Data panel, and drop it above the 'Quantity Purchased' measure. (This creates a facet chart containing multiple sub-graphs.)
d. From the 'Dimensions' node in the Data Source panel, drag the 'State' dimension to the 'Color' field in the Visual panel. This creates a subseries based on the 'State' field.

5. Drag the Chart handles to enlarge the Chart as desired.
6. From the 'Dimensions' node in the 'Data Source' tree, drag the 'State' dimension onto the Viewsheet grid. This creates a 'State' Selection List.
7. Select the following states in the 'State' selection list: 'AZ', 'CA', 'NJ', 'NY'.
8. Right-click the plot area of the chart, and select 'Plot Properties' from the context menu. This opens the 'Plot Properties' dialog box.
9. Enable the 'Show Values' option, and click 'OK'.

This displays the aggregated measure value for each group on the chart.

10. In the Data panel of the Chart Editor, click the 'Edit Measure' button next to the 'Quantity Purchased' measure. This opens a pop-up panel.
11. In the 'Calculate' menu of the pop-up panel, select the 'Custom' option.

12. Click the 'Edit' button to open the 'Chart Calculation' dialog box.
13. In the 'Chart Calculation' dialog box, select 'Percent' from the 'Calculate' menu.
14. Select 'Category' from the 'Of' menu, and click 'OK' to close the dialog box.

15. Click the green 'Apply' button in the pop-up panel to apply the change.

The aggregated measure for each group is now represented as its percentage of the total aggregate for the corresponding category.
Experiment with the other available representations for the group aggregates:
• Grand Total: The aggregated measure for each group is represented as its percentage with respect to the entirety of chart data.
• Subtotal: The aggregated measure for each group is represented as its percentage with respect to the entirety of data on the same sub-graph (i.e., the region, 'USA East' or 'USA West').
• Region: The aggregated measure for each group is represented as its percentage with respect to its entire region (same as 'Subtotal' for this example).
• State: The aggregated measure for each group is represented as its percentage with respect to its entire state.
| << Calculation Methods | © 1996-2013 InetSoft Technology Corporation (v11.4) | Change Calculation >> |