Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

pivot tables

ResolvedVersion 2016

Jon has attended:
Excel Advanced course

Pivot tables

is it possible to take the following date data and show it as a quarterly report? i.e.Jan/Mar, Apr/Jun, Jul/Sept, Oct/Dec
01.02.2018
01.12.2017
12.02.2018
12.12.2017

RE: Pivot tables

Hi Jon

Right mouse click on the date headings on the pivot table and select GROUP.

This should present you with a range of options for grouping your dates including QTR.

Regards

Dennis

Tue 14 Apr 2020: Automatically marked as resolved.

Excel tip:

Create a unique items table from a duplicating table

1. Ensure that your list has column headings
2. Select the entire list
3. From the menu bar, select DATA, FILTER, ADVANCED FILTER
4. Select "Filter the list, in place", and tick the "Unique Records Only" box
5. Click OK, filtered list appears.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.