PivotTable Report Terminology

The following terms are used in PivotTable reports: • Field: The header at the top of a column in a List (data source table). • Item: Numeric ...

Rules for Organizing the Source Data in Excel Sheets

The rules for organizing the List to create a PivotTable report are as follows: • The List can have only one header row. • All cells in the he...

Adding Additional PivotTable Reports Using the Same Data Source

To create several PivotTable reports with different structures from one data source: Option 1: Assuming a PivotTable report has already been create...

Adding a Calculated Percentage Field

To add a calculated percentage field: 1. Select any cell in the Pivot Table report. 2. In Excel 2002 & Excel 2003: In the PivotTable Field Lis...

Pivot Table - Grouping dates by weeks in Microsoft Excel

You will certainly want to create groups of seven days that begin with the first day of the week. To do so, you must locate the first Sunday or Mond...

Grouping the Date Field by Number of Days

To group the Date field by number of days: 1. Drag the Date field from Page (the fields in the top left corner) to Row (to the left of the data are...

Getting Drill-Down Details

To get full drill-down details: In the PivotTable report, select a cell in the Data area for which you want to get drill-down details and double-cl...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Youtube