PivotTable report - Grouping the Date Field by Days, Months, Quarters, and Years

To group the Date field by days, months, quarters, and years: 1. Drag the Date field from Page (the fields in the top left corner) to Row (to the l...

Adding Sub-Details to an Item

To add sub-details to an item: 1. Select an item in the row field (in the screenshot, the selected item is Cost of Sales) and double click. 2. In ...

Formatting a PivotTable Report

To format a PivotTable report: 1. Select a cell in the PivotTable report. 2. Click the Format Report icon on the PivotTable toolbar. OR Press Alt+...

Hiding Items

To hide items in a PivotTable report: In Excel 97, double-click the name of the leftmost Row field, and in Hide Items, select the item to hide, and...

How to Display the Top/Bottom 10 Items in Excel

In this article, we will learn How to Display the Top/Bottom N Items in Excel. Scenario: Pivot table is the most popular tool to calculate, ...

Adding/Deleting Subtotals

To add subtotals to a PivotTable report: 1. Drag at least two fields to the Row area that is left of the Data area). 2. Double-click the left Row ...

Automatically Refreshing a PivotTable Report

Pivot table is an excellent feature of Excel that lets user make summary report from various perspective/angle. There are two ways we can refresh pivo...

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.