I really like the pivot table option but would love to see an option to group by quarter (as compared to by month or week) when displaying the information in a chart. Does anyone have a suggestion for how to do that? Thanks!
Right click a date in the date range value and choose an option in the “Create Pivot Date Group” menu.
Perfect, so easy and yet I never would have figured that out. Thank you so much for the concise, timely, and accurate response. Much appreciated!