Calculate Percentage between Two Columns

You can easily calculate the percentage between two columns. Select the columns you need by clicking the column headers while holding down the CTRL or SHIFT keys.

Right-click the column header on the selection and select Quick Calculation > Math > Division.

Notice that the division calculation shows divisions across Summaries and Grand Total automatically.

Right-click the new column header and select Custom Numeric Format.

Choose Percent and click OK.