In some cases, CPAs find they want to further refine their PivotTable reports using Excel’s full complement of editing tools, but their hands are tied by the PivotTable structure. In this situation, ...

How to create a PivotTable in Excel. We want a simple PivotTable that reports monthly sales by the region, based on the Table shown in Figure A. You can also work with a normal data range.

How to build a PivotTable in Excel. This section is a tutorial on building a PivotTable. If you know how to build one, you can skip this section.

Q: How do I add a percentage-of-total column in a PivotTable in Excel 2010? A: The October 2011 JofA Technology Q&A column (page 76) included an item titled “Make a Difference With PivotTables,” which ...

Go to the PivotTable Analyze tab, choose Fields, Items & Sets, and click on Calculated Item. Assign a name to your calculated item and define the formula using the item names from your data.