G Guest Aug 9, 2006 #1 I have a Pivot table where there are single dates in columns. And I need to arange them by weeks (7 days), not 1 day.
I have a Pivot table where there are single dates in columns. And I need to arange them by weeks (7 days), not 1 day.
E Ed Robichaud Aug 11, 2006 #2 Right-click on the series data (your day-day columns) select properties, select "Filter & Grouping, select "Group by", select weeks, select "Interval".
Right-click on the series data (your day-day columns) select properties, select "Filter & Grouping, select "Group by", select weeks, select "Interval".