Forum Discussion
Fitzpad123
May 06, 2022Copper Contributor
sorting dates
Hi, i have a list of dates where an activity (installation) occurred...and I would like to build a graph showing the volume of installations per day - across a period of several years. e.g. over ...
- May 06, 2022
See the attached file. The data table has full dates displayed. The pivot table summarizes by month.
Fitzpad123
May 06, 2022Copper Contributor
I dont seem to be able to find this can you advise please?
If I highlight a DATE and choose format cells, I dont see any options that only show month and year...they all include the day of month
If I highlight a DATE and choose format cells, I dont see any options that only show month and year...they all include the day of month
mathetes
May 06, 2022Gold Contributor
See the attached file. The data table has full dates displayed. The pivot table summarizes by month.