Displaying Percentage in a Pivot Table

The Pivot Table below shows how much revenue was generated per country. Rather than displaying an amount, the Sales Director wants to see each revenue figure as a percentage of the total. Step 1 Click the drop down arrow next to Total revenue in the Values section...

Sorting a Pivot Table

Step 1 The Pivot Table in the screenshot below is sorted alphabetically by country. However, it needs to be sorted by Revenue in descending order Step 2 Click the filter arrow on the Pivot Table (1) and select More Sort Options (2) Step 3 Select Descending (1) Click...

Pivot Tables in Excel 2011 (Mac)

A Pivot Table is an interactive table that automatically extracts, organizes, and summarizes your data. You can use a Pivot Table to analyze the data, make comparisons, detect patterns and relationships, and discover trends. This short video is taken from a recording...