I'm sure I've done this before but just can't remember how.I've created a pivot table where I have a date field along one of the table axis.So I end up with hundreds of entries one for each date.I thought there was a way to automatically group the dates by year or by year and month, but I can't find it.Any ideas?
I don't use pivot tables so this may be totally wrong! This is for Excel 2003.Click on a date. On the Pivot Table toolbar click on PivotTable, then on Group and Show Detail, then on Group.
VogThanks, you are right and that was what I was doing, I just found some blank rown in my data table that were stopping the grouping from working.Sorted now.
This thread is now locked and can not be replied to.
OnePlus 5T review
How to draw a mandala
iPhone X review
Les meilleures enceintes Bluetooth à moins de 150 euros
© Copyright 2017 IDG UK. All Rights Reserved.