Forum home » Delegate support and help forum » Microsoft Excel Training and help » Pivot tables

Pivot tables

ResolvedVersion 2016

Mon 6 Apr 2020, 15:14 Delegate Jon said...

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

Tue 7 Apr 2020, 14:50 Trainer Dennis said...

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.

Training courses

98.7 % recommend us

More live stats...

Training information:

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

Pivot tables

Pivot tables

RE: Pivot tables

Excel articles

Excel tip:

Create a unique items table from a duplicating table