Jamsandwich
New Member
- Joined
- Sep 25, 2014
- Messages
- 44
Hey guys,
I've generated a pivot table with dates as Row Labels. The source data has several entries for each day so I've had to group the Row Labels by day.
This has had the effect of taking out the year from the dates (now dd-mmm). So when the data goes back beyond the beginning of this year, last years dates are automatically sorted to the bottom of the dataset.
I know that I can group by year too, but this adds rows that I don't want (I have another table being generated from the pivot table rows, important that row data remains as is).
Is there a way to group the rows by day while retaining dd-mmm-yy format? Or can I get the year to appear in a seperate column rather than a row?
Excel 2010.
I've generated a pivot table with dates as Row Labels. The source data has several entries for each day so I've had to group the Row Labels by day.
This has had the effect of taking out the year from the dates (now dd-mmm). So when the data goes back beyond the beginning of this year, last years dates are automatically sorted to the bottom of the dataset.
I know that I can group by year too, but this adds rows that I don't want (I have another table being generated from the pivot table rows, important that row data remains as is).
Is there a way to group the rows by day while retaining dd-mmm-yy format? Or can I get the year to appear in a seperate column rather than a row?
Excel 2010.