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

How to group dates by number of days in Excel

In this article, we will learn How to group dates by the number of days in Excel. Scenario: Problem is when we have a set of date fields in ...

How to show details in pivot table in Excel

In this article, we will learn How to show details in the pivot table in Excel. Scenario: Problem pivot table is a powerful tool to summariz...

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.