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