In cell B3 divide the second years sales 59863400 by the first year 48500000 and then subtract 1. Individual sales person sums are shown as percentage of Grand Total. For a percent of total calculation think of a pie chart where each month is a slice and all the slices add up to 100.
If you are using Excel for the web click Home Number Format Percentage.
Once you select of Grand Total in the dropdown menu and press OK your PivotTable values are shown as percentages. To calculate percent of a total ie. For a percent of total calculation think of a pie chart where each month is a slice and all the slices add up to 100. To find the percentage difference between any two numbers first subtract the smallest number from the bigger digit and then divide the outcome of subtraction with the smallest number among them.