Excel 2016 for Windows Pivot Tables by Tim Hill

Author:Tim Hill [Hill, Tim]
Language: eng
Format: epub, mobi
Tags: Computers
Publisher: Questing Vole Press
Published: 2015-07-05T23:00:00+00:00

In the pivot table, right-click any cell in the Order Date (Rows) column and then select Group from the shortcut menu. The Grouping dialog box opens. In the By list, select Months and Years. Verify that the starting and ending dates are correct and then click OK.

The Order Date items in the pivot table are grouped by years and by months. Excel also creates a new virtual field named Years in the Rows box, which you can pivot on (drag Years to the Columns box, for example). To remove the grouping, right-click any cell in the Order Date (Rows) column and then choose Ungroup.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.