Microsoft Office Tutorials and References
In Depth Information
Examples of Filtering Your Data
Figure 14-45: You can use your newly created time dimensions just like a normal pivot field.
Creating a percent distribution view
A percent distribution (or percent contribution) view allows you to see how much of the total is made
up of a specific data item. This view is useful when you’re trying to measure the general impact of a
The pivot table, as shown in Figure 14-46, gives you a view into the percent of sales that comes from
each business segment. Here, you can tell that bikes make up 81 percent of Canada’s sales, whereas
only 77 percent of France’s sales come from bikes.
Figure 14-46: This view shows percent of total for the row.
You’ll also notice in Figure 14-46 that this view was created by selecting the % of Row Total option in
the Value Field Settings dialog box. Here are the steps to create this type of view:
1. Right-click any value within the target field.
For example, if you want to change the settings for the Sales Amount field, right-click any
value under that field.
2. Select Show Values As.
3. Select % of Row Total.