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. Figure A ...

In the Tables group, click PivotTable and then choose From Table/Range in the dropdown. In this case, Excel will base the PivotTable on TableCalls2. In the resulting dialog, click Existing Worksheet.

Background: (Feel free to skip)I'm starting a project here at work to explore using OLAP techniques to start working more intelligently with our data.Towards this end I got familiar with Microsoft ...