Question: can pivot tables calculate percentages?
Answer: Calculate a percentage for subtotals in a PivotTable. To show percentages such as % of Parent Total, % of Grand Total or % Running Total In in a PivotTable, choose from the Show Values As options. ... Right-click the value field in the PivotTable, and then pick Show Values As. Click the option you want.