PivotTables are great for quick analysis, but they break down when you rely on them for serious reporting workflows.
Q: How do I add a percentage-of-total column in a PivotTable in Excel 2010? Your PivotTable will now display the same two columns of data both numerically and as a percentage of total, as pictured ...