I’m kind of stumped on this one.
I have a Pivot Table with Columns by a Date Value named Week of:
When “Group Dates by” is set to Day, I get:
When “Group Dates by” is set to Week, I get:
I really need the Year to show in the header.
Preferably, I need to Group by week (as that reduces the number of potential groupings.)
The field being rolled up in the pivot table is formatted to mm/dd/yyyy.
I swear I remember having a pivot table with years in the headers in past, but maybe I’m just getting old.